The filtering query is being created dynamically, so "AND" is being used in there. AND has higher precedence than OR in MySQL, and that's why this happens. To bypass it, please use this query:
SELECT * FROM test
WHERE (HandlowiecID = 7 or HandlowiecID = 8)
Hi,
why when I add the second condition the search does not work properly. In the attachment below is a short film.
https://drive.google.com/file/d/1UWe0Nrpv-QAjCdbynBvMdY0JzrtIMtMv/view?usp=sharing
Hello Tymek
Can you send me that database table, so I can try it out locally?
Since this is a public ticket, please make sure to enable the PRIVATE response.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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
Hello Tymek.
The filtering query is being created dynamically, so "AND" is being used in there. AND has higher precedence than OR in MySQL, and that's why this happens. To bypass it, please use this query:
It works fine like this.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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