Listgrid: Sort and filter only by server (without local cache)

[deepmessage]

Hello community!

If you say a listgrid to fetch its data and all data are in local cache, SmartClient tries to sort and filter clientside.

Does anybody know how to tell the listgrid not to do this? It should always fetch data by asking the server (this is not very performant, but I need this cuz filtering and sorting joins tables in the database, so only sorting by "text" is wrong).

Kind regards - and MERRY CHRISTMAS!
Alex

[deepmessage]

any idea?

Kind regards
Alex

[swetan]

I think the following code in the ListGrid should work :

addDataArrivedHandler(new DataArrivedHandler() {
			public void onDataArrived(DataArrivedEvent event) {
				getResultSet().setUseClientFiltering(false);
			}
		});

[Isomorphic]

Use setDataProperties instead.

[deepmessage]

Thanks at all.

This worked:

isc.ResultSet.addProperties({ useClientFiltering:false });
isc.ResultSet.addProperties({ useClientSorting:false });

[gilcollins]

swetan your solution works, thank you

Isomorphic could you show an example of what your proposing and what the difference is?

[Isomorphic]

The specific API is listGrid.setDataProperties().

[gilcollins]

So the proper example would be this ?

This looks the same just made longer...please explain.

addDataArrivedHandler(new DataArrivedHandler() {
			public void onDataArrived(DataArrivedEvent event) {
                                ResultSet rs = myListGrid.getResultSet();
				rs.setUseClientFiltering(false);
				myListGrid.setDataProperties(rs);
			}
		});

[Isomorphic]

No, call setDataProperties when the grid is constructed, and do not have an onDataArrived handler at all.

[gilcollins]

Works perfectly, thank you.

ResultSet rs = new ResultSet();
rs.setUseClientFiltering(false);
myListGrid.setDataProperties(rs);