columnControl searchList not working for Booleans and numbers
columnControl searchList not working for Booleans and numbers
TerraX3000
Posts: 18Questions: 6Answers: 1
Link to test case: https://live.datatables.net/tiwevaji/1/
Description of problem:
The columnControl searchList option is not working for Boolean data types and number data types.
The test case https://live.datatables.net/tiwevaji/1/ demonstrates this issue.
| Data Type | Search Number | Search Text | Search List |
|---|---|---|---|
| Number | ✅ | ✅ | ❌ |
| Boolean | - | ✅ | ❌ |
| Text | - | ✅ | ✅ |
Observations:
The searchList correctly lists the options for all data types.
However, selecting an option from the searchList does not filter the table for Boolean and number data types.
Link to Ajax data: https://dummyjson.com/todos
Answers
Hi,
Many thanks for the test case and clear description (as before)
.
I've committed a fix and the nightly build now has the change. This is the updated example with the nightly.
It comes down to the fact that DataTables does string based search, but the conversion for where booleans (etc) become strings isn't in the right place. I've got a note to change that for DT2.4. The change in ColumnControl is a workaround for the moment.
Regards,
Allan
And thank you again for the quick fix, Allan!