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

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

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

Best Regards

Tony

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

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)

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

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

Discussed many times. Will be maybe in 3.7 release.

Regards

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