jQuery Grid Plugin - jqGridForum

Topic RSS

Client side filtring

20/10/2009
08:19

sarfraz.m.b

New Member

Members

Forum Posts: 1

Member Since:
20/10/2009

Offline

Hi Tony,

I recently started using JqGrid and the thing is i want search to be on client side since i dont want the grid data spread on multiple pages. Do we already have something already like this?

If not do i need to write code that does client side filtring?

Thanks,

Sara

21/10/2009
05:40

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

Hello,

Discussed many times. Will be maybe in 3.7 release.

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.

16/02/2010
17:04

Mike Bosworth

Member

Members

Forum Posts: 3

Member Since:
16/02/2010

Offline

Hi Tony,

Just wanted to add my support for this.

Client-side search appears to be the only essential, very basic feature that jqGrid lacks.

Looking forward to 3.7.

Cheers,

Michael

16/02/2010
20:06

Renso

Member

Members

Forum Posts: 118

Member Since:
11/09/2008

Offline

Mike/Tony how would this work. Only the first page's data is returned, you don't want 10000 accounts passed over the network to the browser so you can only show 10 on a page, when you now do client side filtering, only the first 10 rows (as in this example 10 rows per page) will be filtered, you would loose the data that would have come up in the filter from page 2 and up? Am I not understanding you correctly Mike or what?

16/02/2010
22:21

Mike Bosworth

Member

Members

Forum Posts: 3

Member Since:
16/02/2010

Offline

Hi Renso,

In answer to your first question - client-side filtering usually just filters the visible data. Google "javascript grid," click on the first result, and I believe you'll find an example: http://dhtmlx.com/docs/product.....htmlxGrid/. From what I understand, that grid implementation offers both methods of filtering, client-side and server-side.

In answer to the last: I think you are understanding correctly. Some client-side features - like filtering and sorting - are precluded by very large data sets. Consider, for example, 100,000 rows of grid data. As you suggest, client-side filtering would not be desirable in such a case, due to the performance issues.

But in other cases, where there are, e.g., several hundred rows of grid data, or even fewer, it becomes quite feasible, not to mention convenient for the user and better-performing, to load all of that data to the client-side all on one page and have it sorted there and filtered there.

Thanks,

Mike

23/02/2010
20:24

Renso

Member

Members

Forum Posts: 118

Member Since:
11/09/2008

Offline

Thank you for atking the tmie to ellaborate Mike. For a moment there I thought I have fallen of the bus so to speak 🙂 Makes perfect sense.

14/04/2010
01:35

ddotsenko

Member

Members

Forum Posts: 15

Member Since:
08/03/2010

Offline

Local searching was possible for a long time.

You just have to decide what "local searching" means to you and implement override the "load" functionality through custom function. Per wiki and docs, 'grid.p.datatype' can be a function. All "load" requests, both with "filter" and without, are routed to it, instead of $.ajax when grid.p.datatype is a function.

Just parse the filter rules by hand in the browser and load the filtered data back into grid.

My definition of "make jqGrid work against local storage" is:

Have actual COMPLETE data sit in the browser. Say, an array with some 35 rows are attached to grid.p.dataStore.data.

Set up the function that reads paging, sorting, filtering arguments in the 'postdata' and returns proper subset of the data back (through a call-back like gridObj.addJSONData() ) . Attach that function to grid.p.datatype

That's it.

Example is here: http://www.accentsolution.com/.....store.html

(Posting date - April 2010. Link may be gone in a few months)

21/04/2010
01:43

Mike Bosworth

Member

Members

Forum Posts: 3

Member Since:
16/02/2010

Offline

Hi ddotsenko,

Thanks very much for that outline of how to implement this feature myself. As you say, it is possible to do. I would certainly hope so - I requested it!

If need be I'll write up and use my own filter, since it doesn't seem too time-consuming to write. But given that it's such a useful (and, I think, normal) feature, I thought I would request it for the official jqGrid package.

Thanks again,

Mike

21/04/2010
20:38

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

Hello,

We are just in alfa release of this feature. We will make it offically soon.

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.

30/07/2010
01:06

archan.bhatt

Member

Members

Forum Posts: 19

Member Since:
29/07/2010

Offline

Tony,

When are you going to release local filtering functionality? Right now we have that functionality when we set loadonce to true, but I have several thousands rows, so can not perform that way.

I am really waiting for as a official release.

Thanks.

Archan

02/08/2010
18:18

archan.bhatt

Member

Members

Forum Posts: 19

Member Since:
29/07/2010

Offline

tony said:

Hello,

We are just in alfa release of this feature. We will make it offically soon.

Best Regards

Tony

Hey Tony,

Is there any way to set loadonce : true programmatically (PHP) if total number of rows (row count) is less than # numbers and false if not?

Thanks.

Archan Bhatt