Grid: Paging of JavaScript Array already in memory

[trbs]

cool

i knew there was a reason why i did params.start !== undefined and not just if(params.start) in my earlier version... that was it

[jt]

Using this as a base, would it be possible to take this further?

The problem I am now facing is that the data displayed in the grid is just summary data.
I need to be able to filter via the detailed data which is in the database. And to top it off I am also using DWR.

So is it possible to combine filtering for the in memory grid data while doing a server call to filter via detailed data from the database. Or is it better to do all the filtering on the server and just return the results to the browser?

Here's an example:
I want to display summary information about a user (first name, last name, address), but I also want to be able to filter the data via fields that are not displayed in the grid (birth date, age, personal notes, etc).

I might be complicating things more than they need to be, so any help would be appreciated.

[trbs]

Using this as a base, would it be possible to take this further?

The problem I am now facing is that the data displayed in the grid is just summary data.
I need to be able to filter via the detailed data which is in the database. And to top it off I am also using DWR.

Sorry i have no experience with DWR and what implications that has on your question. (i hope none )

So is it possible to combine filtering for the in memory grid data while doing a server call to filter via detailed data from the database. Or is it better to do all the filtering on the server and just return the results to the browser?

Personally i think it's better to just do the filtering on the server, it's most likely easier then messing around with it on the client. (specially if you want to split the user list and user details)

Here's an example:
I want to display summary information about a user (first name, last name, address), but I also want to be able to filter the data via fields that are not displayed in the grid (birth date, age, personal notes, etc).

I might be complicating things more than they need to be, so any help would be appreciated.

Sure i think that can be done. You'll most likely could end up with overwriting most of the Store's components. (Proxy and Reader) To make them behave like you want to.

As long as it isn't a problem for u to keep all data in memory then you can search the non-showed data as easily as the data shown in the grid. (your searching the underlying data store, not the grid itself) Otherwise u will just query the server again for user details and then the possible speed gain of client side filtering is gone anyways.

But if u can, start with serverside filtering, that's what is most commonly used in Ext and the easiest to build. (and you can always which over in the feature)

[pianoroy]

I tried the PagingMemoryProxy. It's cool. But I'm going back to HttpProxy()...

Reason is I find the ds hard to manipulate, especially when adding new row or deleting rows.

In particular, ds.reload() doesn't do anything. Maybe I missed something.

Is there any way to load a new dataset into a BufferedMemoryProxy after it has been created?

I have an iTunes-like interface that loads data into the grid whenever the user makes a selection above. I'm trying to use BufferedMemoryProxy (see earlier in the thread), but I can't figure out how to load a new double-nested array into it. If I'm using no paging, the following works great:

data_store.loadData(data);
data_store.fireEvent('datachanged');

Is there an equivalent that pipes the data through a BufferedMemoryProxy?

[pianoroy]

Is there an equivalent that pipes the data through a BufferedMemoryProxy?

Yes, there is. I just found it.

delete data_store.proxy.data;
data_store.proxy.data = data;
data_store.load({params:{start:0, limit:page_size}})
data_store.fireEvent('datachanged');

Hope that helps someone.

[pianoroy]

Jack, is this the "advisable" way to do it, or is there a better way?

[heidtmare]

This PagingMemoryProxy has been awesome for me.

I've noticed that since I'm loading from memory the refresh button is completely worthless.
How do i turn it off?

[heidtmare]

In addition: if i turn on column sorting, it only sorts what is in the current page.
How would i make it sort the entire store and refresh to the current page?

[dogomatic]

Add remoteSort: true to your data.Store config.

[hendricd]

You'll need to replace this function:

var fn = function(r1, r2){
    return r1 < r2;
};

with:

var fn = function(r1, r2){
    return r1 == r2?0:r1 < r2?-1:1;
};

to get the sorting to work properly.