Is it possible to make the wpDataTables search more sophisticated, such as using quotation marks to require an exact phrase or other Boolean search capabilities such as AND and OR?
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
in that case, Exact filtering will be enabled always for columns made to pull foreign key values.
You might try this as a workaround, and see how it behaves for Table Search, but i am not sure if that will help for your specific use-case.
-
In regards to AND and OR filtering, in the Column Filtering options;
With Multiselectbox and Checkbox filters, you can enable the AND filtering logic.
wpDataTables uses the OR logic by default, so the results need to match only one of the selected conditions, while the AND logic filters the data and the results must match all of the selected examples.
Please note: The AND logic is also available in the Powerful Filters add-on.
Is it possible to make the wpDataTables search more sophisticated, such as using quotation marks to require an exact phrase or other Boolean search capabilities such as AND and OR?
Hi, Randy.
If i understood, you would like to have this for the global Table Search block?
For the Table Search itself, we do not have this yet, but it is a good idea for a future option.
Please feel free to search on our suggestions page,
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
-
For the advanced column filtering though, we have added "Exact filtering" option.
-
If you use a Foreign Key Relation Column -
in that case, Exact filtering will be enabled always for columns made to pull foreign key values.
You might try this as a workaround, and see how it behaves for Table Search, but i am not sure if that will help for your specific use-case.
-
In regards to AND and OR filtering, in the Column Filtering options;
With Multiselectbox and Checkbox filters, you can enable the AND filtering logic.
wpDataTables uses the OR logic by default, so the results need to match only one of the selected conditions, while the AND logic filters the data and the results must match all of the selected examples.
Please note: The AND logic is also available in the Powerful Filters add-on.
-
Let me know if you have any additional questions.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables