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?
Thanks.
1 Answers
Your Answer