Replies

• allan Posts: 65,304Questions: 1Answers: 10,830 Site admin

  November 2022

  Hi Dave,

  There are two options:

  1. Use the method you found on Google with a hidden column containing the data to search. I would actually say this is relatively efficient since it is reusing the DataTables column search ability. It does mean there would be duplicate information in the HTML is the downside in terms of efficiency.
  2. Use a custom search plug-in that will match on the row id attribute. I suspect this will have slower performance since you need to get the DOM attribute for the row each time it is run. With column search we can cache the value, but reading a value from the DOM is always slow (depending on the number of rows, it might or might not be noticeable).

  Allan
• Dave333 Posts: 6Questions: 2Answers: 0

  November 2022 edited November 2022

  Hi Allan,

  Thanks for the (speedy!) reply, ver much appreciated.

  No.1: clear.

  About no.2: i was hoping that DataTables would store an array or object of sorts which holds the relationship between the id of a row and its index so that one could efficiently filter/search the DataTable by providing that index (or id).

  Do i understand correctly that there is no direct way to show only one row by providing an index for that row? (Or more preferred: by the id of that row)

  The reason i'm asking is because i have an input field which value is '8000 - turnover' while it has an attribute with an the id for that value.

  If the user opens a dropdown (which holds the DataTable) for that input field, that DataTable should only show one row: the 8000 one.

  So a search, not by a value (because the value in the input value is different than in any of the DataTable columns) but by the index of that row. Or even more practical: by the id of that row.
• colin Posts: 15,240Questions: 1Answers: 2,599

  November 2022

  If you use that first approach, the hidden column, you can search explicitly by the hidden column with column().search(), rather than across all columns with search(). You can use regexs to make it more specific, i.e. ^value$, which would work with both global and column searches.

  Colin
• Dave333 Posts: 6Questions: 2Answers: 0

  November 2022

  Thx Colin (and Allan), i'll try that. Hopefully it'll work.

  Maybe it's a thought for a next version of DataTables, adding the possibility to search for a row attribute(s) and show only that row / rows? Or maybe add the ability to access an array or object which holds the relation to the row id of a row and its index?

  For now i'll try your solution.
• kthorngren Posts: 22,314Questions: 26Answers: 5,130

  November 2022 edited November 2022

  Or maybe add the ability to access an array or object which holds the relation to the row id of a row and its index?

  You can get this relationship using a Search Plugin. See this example:
  http://live.datatables.net/ruvizuku/1/edit

  Among other parameters the search plugin provides the row index and the original row data (rowData). The original row data contains the row ID as an object and can be accessed using rowData.DT_RowId.

  Use the search plugin to search by row index or row id. In your search input event handler store the input value’s “ID" in a global variable then use the draw() API to run the plugin. In the plugin use the global variable compare to the rowData.DT_RowId to display or hide the row.

  If you want help with this then please build a simple test case that we can use to help apply your search input to the search plugin.
  https://datatables.net/manual/tech-notes/10#How-to-provide-a-test-case

  Kevin