Forum


22:20

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'))
18:50

Moderators
30/10/2007

Hello,
Thanks for this. This will wait for 3.7 maybe.
Best Regards
Tony
For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.
Most Users Ever Online: 715
Currently Online:
42 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66