Keep the index value after a search

lionellionel

Hello everyone,

I find an answer from this question but It was quite old and I wasn't able to use it properly

I would like not to reinitialize the index after a search in order to have it logical. I create a fiddle to display the problem, when I write something in the input field, the index is recalculated and I would like to avoid that.

jsFiddle : https://jsfiddle.net/margarette/dr5o1v32/1/

Thank you in advance

Lionel

kthorngren

Instead of using the order and search events to process the indexes use the init event so it runs once at initialization.

Kevin

lionellionel

Thank you for your answer @kthorngren ,

I replaced the order Event and the search Event by the init Event but it still doesn't work.

kthorngren

Yes, you are right. The init invocation is after the Datatable has initialized so it does nothing Use initComplete instead, like this:
https://jsfiddle.net/rv9nz7u5/

Kevin

lionellionel

Thank you!

It works but not perfectly. If I search with 2 as a value, the line with the index 2 disapeared. Any idea to keep it?

kthorngren

Use columns.searchable to define which columns you don't want to search.

Kevin

lionellionel

Thank you for your answer.

Even with searchable: true, the line disappeared and the ordearable option doesn't work for the ID column.

https://jsfiddle.net/margarette/8ygcsbm1/13/

kthorngren

You need to use searchable: false to not search the column. Even with searchable: false the row with index 2 will be hidden when search for 2 because no other data in that row has a 2:

2   Ashton Cox  Junior Technical Author San Francisco   66  $86,000

Kevin

lionellionel

Is there any way to have it include in the search result?

kthorngren

Sorry, I misunderstood the question. I thought you didn't want it included in the search. You will need to use rows().invalidate() to have Datatables refresh its data cache after applying the indexes. For example:
https://jsfiddle.net/my1htckz/

Kevin

lionellionel

Thank you for your answer!

I finally used an index stored in database, easier to maintain and manage for me.

Thank you a lot for your help!

kthorngren

Thats a very good way to keep indexes

Kevin