I just wanted to know if there is a way to modify jqGrid to allow “nested searching”.
Right now the multiple search dialog will let you dictate any or all which would mean AND and OR in my SQL.
I would like the user to be able to build more complex filtering from this dialog window.
ColA = 'ASD' AND
ColB = 'FGH' OR
ColC = 'JKL'
Using both an AND and an OR and find some way on the _POST to build the SQL right with the nested queries.
WHERE (ColA = 'ASD' AND (ColB = 'FGH' OR ColC = 'JKL'))
Copyright 2014 TriRand LtdAll Rights ReservedRSS
Back to Top