Forum
Log In
Home
Topic RSS
12:34
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.....
13:19
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
13:21
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....
13:23
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....
13:54
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
16:21
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..
Most Users Ever Online: 715
Currently Online:
39 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
