Forum

May 22nd, 2014
A A A

Please consider registering
guest

Log In Register

Register | Lost password?
Advanced Search

— Forum Scope —

  

— Match —

   

— Forum Options —

    

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

Topic RSS
jqgrid filtering
23/08/2010
12:34
asb1986
Member
Forum Posts: 7
Member Since:
05/08/2010
Offline

Hello... Iwant to implement filtering in my jqgrid... May i know how to start with this????? ANy ample code, documentation telling how to use filtering in this... I am using jqgrid in my spring mvc3.0 project.....

23/08/2010
13:19
OlegK
Germany
Member
Forum Posts: 1233
Member Since:
10/08/2009
Offline

Hello!

The answer on your question depends a little how you interpret the "filtering". If you want use some external controls (selects, checkboxes and so on on the same page where you have jqGrid) to filter your data I recommend you to read http://stackoverflow.com/quest.....19#2928819

If you want to implement data filtering inside of jqGrid you can choose between serching with respect of "search" and reset of serching results with respect of "refresh" buttons of the /jqgridwiki/doku.php?id=wiki:navigator) action which provide the grid data or add three string parameters searchField, searchString, searchOper if you want to use simple searching feature. In all cases you will have to add WHERE to the SELECT statments which will be constructed in your program based on the values of the new parameters.

Probably other people post you more urls to the good full code examples which you could use.

Best regards
Oleg

23/08/2010
13:21
asb1986
Member
Forum Posts: 7
Member Since:
05/08/2010
Offline

Thanks for your reply... Its like i want to filter my records depending on dates.... as in... "from" date till "to" date... in such a case, how to go about this thing... and secondly, database hit should be minimum....

23/08/2010
13:23
asb1986
Member
Forum Posts: 7
Member Since:
05/08/2010
Offline

one more thing i wish to ask... does spring mvc3.0 affect any coding of this filtering facilty???? cos i find jqgrid examples with php and asp.net mvc... but i hardly could find any examples for spriing mvc3.0....

23/08/2010
13:54
OlegK
Germany
Member
Forum Posts: 1233
Member Since:
10/08/2009
Offline

I don't use Spring Framework myself, so I could not help you with any Spring MVC 3.0 examples. Some general solution is more common. For example in ASP.NET MVC solutions I prefer don't fill the data in the grid directly using MVC. Instead of that I provide a JSON web service (implemented as a part of ASP.NET MVC solutions or as WFC service which are the part of the same web site) which uel I place in jqGrid parameter. So you should just invest in the writing on business logic in form of JSON/XML web service which provide the data. The most jqGrid specific code you can write in JavaScript. So you can share the experience of other people in the usage of jqGrid and have a clear separation of HTML code from the business logic. Moreover JSON/XML web services can be better tested for example with respect of unit tests.

By the way is the question http://stackoverflow.com/quest.....g are yours?

Regards
Oleg 

21/09/2010
16:21
asb1986
Member
Forum Posts: 7
Member Since:
05/08/2010
Offline

Sorry Oleg.. But yes... I had posted the same qs in stack overflow too... I am stuck with jqGrid for implementing sorting, paging, filtering at the server side... I dont know how to start... So posting questions..

Forum Timezone: Europe/Sofia

Most Users Ever Online: 215

Currently Online:
31 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

OlegK: 1233

markw65: 179

kobruleht: 144

phicarre: 132

YamilBracho: 124

Renso: 118

Member Stats:

Guest Posters: 447

Members: 11320

Moderators: 2

Admins: 1

Forum Stats:

Groups: 1

Forums: 8

Topics: 10527

Posts: 31121

Newest Members: Shahid1, sheryl.liang@db.com, JuanPC, Loganathan.S, krish, jqGridForStruts

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

Administrators: admin: 61

Comments are closed.
Privacy Policy   Terms and Conditions   Contact Information