[Solved] Determine filtered rows

[Ray Wu]

Hello there,

I was wondering if there is any way to determine the rows of a data source that has been filtered out in RadGrid? I notice that when I type in a filter, the MasterTableView no longer has the "Item" in its Items array. Is there a way to identify what's filtered out in terms of an index into the original data source?

As a bit of background - I'm trying to export a table as a CSV file. But if I use ExportAsCsv() then the custom columns (that uses a function to render some HTML) doesn't show up in the output. So I'm trying to see if I can determine the filtered-in/out rows and build the CSV myself using the original data source.

If there is another way to achieve what I'm trying to do that would also be great. Your help is much appreciated.

Thanks,
Ray

[Princy]

Hello Chris,

Here's a link to a forum discussion where the solution provided, for a similar case is to re-query the database with the filter expression and store the items in a temporary datatable which can then be used to build the CSV file.
Get items filtered grid and data item(row) is based on

Thanks
Princy.