DataTables
[BUG] Filter does not work properly when entering double quotation marks (`"`)
ISSUE COPIED FROM https://github.com/wet-boew/wet-boew/issues/9497
Describe the bug When trying to filter using quotation marks, the table does not get properly filtered.
To Reproduce Steps to reproduce the behavior:
- Go to datatables.net example table
- Type quotation marks
"into the filter textbox - See error, table won't change until 4 double quotations are entered
Expected behavior Rows should disappear when they don't have quotation marks.
Additional information (optional)
Adding a fourth quotation mark will get it to behave as if there was one quotation mark (hard to show as none of the rows in the example here had quotation marks)
Desktop/Smartphone (please complete the following information)
- OS or Device: Windows 10
- Browser: Edge
- Version:108.0.1462.46 (Official build) (64-bit)
Thank you for the report - agreed, there is something wrong in the handling of the quotes for an exact match string. I'll look into that for the next release.
"this is a limitation of smart searching due to the use of double quotes to do an exact match. Unfortunately the only way around that is to disable the smart search." https://datatables.net/forums/discussion/26785/search-filter-with-a-double-quote-in-the-string#Comment_73006
That is the case for a single double quote yes. But I'm not convinced that the behaviour you are seeing for four double quotes is correct. That said - it will be fairly nuanced due to the exact matching from the double quotes.
A similar issue happens with comma and slash: if you put a comma or a slash in the filter textbox, data does not change. A second comma or slash is needed to see the data changing.
