Change Column Filter options to match overridden values?

[Chris]

I have a GridBoundColumn in my RadGrid that displays a true or false value. In the database, this is stored as a 1 or a 0. During the ItemDataBound event, I check the incoming value for this column and override it to either be the string "TRUE" or the string "FALSE". However, the RadGrid is still identifying the column's datatype as an integer so the filter menu doesn't have certain filtering options like "Contains". I tried to manually set the DataType to "System.String" on both the column itself and during the ItemDataBound event and, while this provides me the filter menu I want, the functions inside don't work (clicking "contains", for example, does nothing at all). 

 

Is there anyway for me to force the filter options to match the values after DataBound?

 

Thanks!

[Eyup]

Hi Chris,

 

You can achieve this requirement by manually changing the filter value during the ItemCommand event handler:
https://docs.telerik.com/devtools/aspnet-ajax/controls/grid/how-to/Filtering/operate-with-the-filterexpression-manually

The property is called column.CurrentFilterValue.

Feel free to give it a try and let me know how it goes.

 

Regards,
Eyup
Progress Telerik