Forum

November 2nd, 2014
A A A
Avatar

Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

The forums are currently locked and only available for read only access
sp_Feed Topic RSS sp_TopicIcon
Multi Search with Multiple Group op?
07/01/2011
21:30
Avatar
johan
USA
Member
Members
Forum Posts: 13
Member Since:
02/12/2010
sp_UserOfflineSmall Offline

 I need AND || OR in the same search.

So what would be sent as filters would be:

filters = 
    {"groupOp":"AND",
     "rules":[
       {"field":"invdate","op":"ge","data":"2007-10-06"},
       {"field":"invdate","op":"le","data":"2007-10-20"}, 
      ]
    }
    {"groupOp":"OR",
     "rules":[
       {"field":"field1","op":"contains","data":"de"},
       {"field":"field2","op":"contains","data":"de"}, 
      ]
    }

This is what is wanted as a possible search. Is this possible? I actually thought the "+" next to the "Match ~ Rules was to add different groupings to the search but all it seems to do is add another field. I can only ever seem to run searches on either AND, or OR, but not both. Thanks, Johan

13/01/2011
22:39
Avatar
johan
USA
Member
Members
Forum Posts: 13
Member Since:
02/12/2010
sp_UserOfflineSmall Offline

I don't mean to bump my own thread but I am bumping my own thread.

Can anyone comment as to if this is possible? Perhaps I did not explain clearly enough? I have looked through all of the documents and I am finding nothing about passing multiple filters with different groupop's.

If jqgrid does not have this capability (the "+" on the dialog would indicate so...) I am wondering if someone could give me a start at how to modify jqgrid to have this ability.

Thanks ahead.

14/01/2011
05:02
Avatar
johan
USA
Member
Members
Forum Posts: 13
Member Since:
02/12/2010
sp_UserOfflineSmall Offline

EDIT: I am finding that the code found in the link below describes well what I am looking for, however, the source code provided is quite bug ridden.

Well I found this. I am going to attempt to implement this into my base jqGrid. Looks difficult, but it seems to be what I am looking for. If I am successful, I will post something.

http://www.codeproject.com/KB/.....ering.aspx

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
49 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.com

Moderators: tony: 7721, Rumen[Trirand]: 81

Administrators: admin: 66

Comments are closed.
Privacy Policy   Terms and Conditions   Contact Information