How to find AJAX data with no column?

andrew45

Data is loaded to a Datatable as AJAX with a structure like {"id":"1","name":"a1","surname":"b1"},{"id":"2","name":"a2","surname":"b2"}, ...

But the Datatable has only 2 columns ("name" and "surname").

How to filter (search) to show only a row with id=1 ? I can't work this out because there is no column with "id".

kthorngren

It depends on how you want to search for the id. One option is to create a hidden column with columns.visible for the id. Another option is yo use search.fixed() as a function. The second parameter data should contain the id along with the other columns.

Kevin

andrew45

Thanks, Kevin. Your second link is 404, so this is a good one:
https://datatables.net/reference/api/search.fixed()

kthorngren

Yep its search.fixed()

Kevin