reload page and save pagination status with active SearcPane filter not possible

themw

Link to test case: https://jsfiddle.net/themw/hdwk42yo/
Description of problem: Hello everyone,
First of all, I use version 1.1.0 of SearchPanes.The reason for this is that since version 1.1.1 the pagination is not saved when the page is refreshed (no matter if a filter is active or not). I could almost solve this problem with version 1.1.0. However, there is still the problem that if I use a filter and refresh the page, the pagination is not saved. Only if no filter is selected, the current page (pagination state) is saved. Does anyone know how to fix this problem?

sandy

Hi @themw ,

Thanks for pointing this out, it should indeed be saving the paging. I've raised an issue internally (DD-1685 for my reference) and will report back here when there is an update.

Thanks,
Sandy

colin

This has now been addressed, and we're hoping to release this in the next week with SearchPanes 1.2.1.

Colin

themw

@colin
I am now using version 1.2.1 and the previous problem no longer exists. A big thank you for your effort.
But there is now another problem. For example, if I am on page two and reload the table using :

table.api().ajax.reload( null, false );

I always return to page one. It does not matter whether filters of SearchPanes are active or not. It seems that reloading with ajax.reload resets the pagination.

kthorngren

table.api().ajax.reload( null, false );

This works here:
http://live.datatables.net/puwuvuyo/1/edit

Please provide a link to your page or a test case showing the issue so we can help debug. You can update my example.
https://datatables.net/manual/tech-notes/10#How-to-provide-a-test-case

Kevin

themw

Unfortunately I cannot reproduce the bug using JSBin or JSFiddle because it is very difficult to reproduce it.

If I enter the following

table.api().ajax.reload( null, false );

the state save of the pagination is possible until I insert

dataTables.searchPanes.min.js
and
searchPanes.bootstrap4.min.js

and then set the SearchPane option, such as

var table = $('#example').DataTable({
searchPanes: {
viewTotal: true,
controls: false,
columns: [3]
},
});

I think that SearchPanes overwrites the storage of the pegination state when it is initialized.

kthorngren

I built a test case for you based on your code snippets:
http://live.datatables.net/puwuvuyo/8/edit

The the case does replicate the issue. @sandy or @colin will need to take a look.

Kevin

sandy

Hi @themw @kthorngren ,

Thanks for working through this to come up with an example. I'd agree with you that that is not the correct behaviour. I've raised an issue internally (DD-1702 for my reference) and will report back here later in the week with an update.

Thanks,
Sandy

sandy

Hi @themw ,

That should be the issue fixed now. SearchPanes was running it's filter after the ajax reload had set the paging, which reset it. Now SearchPanes will take into account the paging set by the ajax reload.

Thanks,
Sandy

themw

Hello,

i could solve the problem now, because i have implemented a live plugin. With this plugin the pagination is not reset.

However, when I use the command table.api().ajax.reload( null, false ); the pagination is still reset. You haven't released a new version, so how should the porbem be fixed?

sandy

Hi @themw

You can access the fix by pulling in the SearchPanes code from the nightly builds. I've modified the example above to show how to do this, and you can see it is working there.

Thanks,
Sandy

DanyVit90

Perfect, it works!

Really thanks!