Grid Filtering Issue

[John]

I have found that a grid field cannot be sorted by anything other than "EqualTo" method if the data type is Number. This is an issue for me so I am attempting to create a custom filter for this column. The filter control must be a text box only, no button so that it behaves just like the built in filter for a radgrid. I have tried to find some example but have not been able to. Below is the client side code for the column but i am stuck as to what to do next

<telerik:GridBoundColumn DataField="INPUT_BY" UniqueName="INPUT_BY" HeaderText="Input By"

         AllowFiltering="True" AutoPostBackOnFilter="true" ShowFilterIcon="false">

<FilterTemplate>

  <telerik:RadTextBox runat="server" ></telerik:RadTextBox>

 </FilterTemplate>
</telerik:GridBoundColumn>

Again the desired functionality is to replicate the built in filter functionality but it MUST be able to filter using the contains filter method on a Number data type. Any ideas on how to code that up? Thanks in advance

[Princy]

Hi John,

If you set 'AutoPostBackOnFilter' to true for a column having data type number, then the default filter function is 'EqualTo'. I guess your requirement is to hide the filter button and show only the filter textbox and filter the data with filter function 'Contains'. Please try the following code snippet. You don't need to add FilterTemplate in this case.

ASPX:

<telerik:GridBoundColumn DataField="INPUT_BY" UniqueName="INPUT_BY" HeaderText="Input By" AllowFiltering="True" CurrentFilterFunction="Contains" AutoPostBackOnFilter="true"   ShowFilterIcon="false" DataType="System.String">
</telerik:GridBoundColumn>

Thanks,
Princy.