[Isomorphic]

Make sure data is present for all criteria supplied to the grid.

Also, if via SQL templating you've set things up so your server-side execution of the criteria doesn't actually apply the criteria as specified (perhaps it matches more records than the criteria would normally match), then any filtering on the client side is going to reduce the matched records to the ones that actually match the criteria. This can create the "inconsistent" results you see but the actual problem is that your server is returning records in that don't match the criteria.

[harsha.galla]

Thanks Isomorphic I get it now.

[harsha.galla]

Isomorphic,

How about the custom criteria fields we set as part of criteria which we later use in ds.xml file or dmi. Does the client side filtering expect these too to be present in the select clause??

Thanks.

[Isomorphic]

The client knows nothing about your SQL or your DMI. It only applies the criteria you provide client side to the data your server returns.