When I define a query to pull the data to the grid from MySql if there is more than two column search strings it breaks the grid search and filters.
For example, I have my custom query as:
SELECT * FROM Customers WHERE Country=‘US’ AND State=‘CA’ OR Country=‘US’ AND State=‘WA’
Anything more than two clauses and all search and filter functionality stops working. Any suggestions?
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?