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?
How useful was this discussion?
Click on a star to rate it!
Average rating / 5. Vote count:
We are sorry that this post was not useful for you!
Let us improve this post!
Thanks for your feedback!