ferhat asked 5 years ago
Hello,
My question is this; how can we search for words contained in a sentence?
For Example Table:
Product Code – Product Name
1000 – CLUTCH KIT QASHQAI 1.5 DIESEL
1001 – CLUTCH KIT ALMERA 1.5 DIESEL
1002 – CLUTCH KIT QASHQAI 1.6 DIESEL
No results when I make that search; "CLUTCH KIT DIESEL", "CLUTCH KIT 1.6" Only finds the words in the sentence if I write them one after the other..
I want to filter all words separately, Do I change my filtering in this way?
A sample filter that works as I said: https://datatables.net/examples/api/multi_filter.html
Thanks,
ferhat answered 5 years ago
Abu Ghufran Staff answered 5 years ago
You can use global search filter for this purpose. The autofilter is designed to use like %word% clause.
For global search, see image:
ferhat answered 5 years ago
Ok,
Can we search on pressing a key as in autofilter in global search?
I want instant search automatically without pressing the button on global search, is it possible?
Abu answered 5 years ago
This is added in latest build. You can email me ([email protected]) your order number or payment email address to get update.
Michael Sinne answered 5 years ago
The global search splits the search string and combines the parts with OR? correct?
Abu answered 5 years ago
Yes, thats correct. However recently we added exact phrase search option as well by double quotes around phrase. e.g “multi word phrase”
https://www.phpgrid.org/september-2019-release-version-2-6-3/
Exact Match in Global Search
To do exact search in global search, you can enclose your query text in double quotes “…”.
