can we have a filterFetch flag true when fetch was invoked by filter?

[affan]

If server fetch was invoked by filter, can we have a flag say a dsrequest param called filterFetch which is set to true? My issue is i have a lot of columns and i have to check for a lot of nulls. server side response time would improve slightly if i knew a fetch was invoked by filter or not.

[Isomorphic]

What do you mean by "invoked by filter"?

[affan]

In my listgrid with setShowFilterEditor set as true. When user enters filter criteria and presses enter, a request is sent to backend (assuming paging is enabled and not all rows were initially returned), in the request i don't see any option that says fetch was triggered by filter and not by paging. I have about 10 columns and in my server side code i am checking all of them to see if any one of them is not null. If all are null then i know filtering criteria was not entered. This seems like a tedious way to do this, a flag would make life much easier... Unless there is already something out there that i am missing?

[Isomorphic]

These requests are not different from the widgets perspective, and should not require any kind of mulling out of fields on your part. None of the builtin connectors treat them any differently or need to do extra work.

[affan]

Ok can you please tell me if my assumption is correct. If there are 1000 rows and i am displaying 75 rows without any filtering. Now lets say if user filters on two columns 'symbol' and 'description', and out of 1000 rows only 200 rows match this criteria, then in my response, i send startRow as 0, endRow as 75 and totalRows as 200, and data which contains 75 of those 200 rows. Is this correct? Or should totalRows still be 1000? am i doing extra work by doing filtering on server side? i thought we need to do that since i am not showing all records to client at once as there are too many.

[Isomorphic]

That's correct, if 200 rows match the criteria, totalRows should be 200.

[inventor]

Hi Isomorphic,

while reading this I have a related question: If the response has 75 records, will endRow be 75 or 74?

With the above numbers: The fetch with startRow = 0 and endRow = 75 will return 75 rows (end row is exclusive here). The DSResponse should be set to totalRows = 200, startRow = 0. Should endRow of the response be set to 75 or to 74?