Getting GridColumn.CurrentFilterFunction value in NeedDataSource handler

[Andy]

Hello!
I ran into a weird problem. When I try to get the value of CurrentFilterFunction in NeedDataSource handler, it returns the value from a previous postback, but not the current selection. CurrentFilterValue returns current value fine though.

I'm trying to reduce the number of records in the data source bind to the grid according to the filter settings chosen by a user. Any ideas how to achieve it the best way?

Thanks!

[Mira]

Hello Andy,

To implement the desired functionality, I recommend that you configure the data source of the grid according to the FilterExpression of the master table view in the NeedDataSource event handler.
Then, to prevent the filtering from the build-in mechanism of the grid, you could store the filter expression and set its property to an empty string. This can happen again in the NeedDataSource event handler.
You should restore the FilterExpression on PreRender of the grid to ensure the correct display of the filter values and functions in the filter item.

Please, give this approach a try and let me know how it goes.

Kind regards,
Mira
the Telerik team

[Andy]

Hi Mira!
Thank you for the suggestion! Do you have any examples on how the value of FilterExpression can be used to adjust the datasource? Do I need to parse it manually? For datasource I'm using a System.Data.DataTable. 

Best wishes,
Andy

[Mira]

Hello Andy,

You can implement the desired functionality by using the DataTable.Select Method (String). It gets the objects that match the filter criteria.

I hope this helps.

All the best,
Mira
the Telerik team