This is a migrated thread and some comments may be shown as answers.

Numeric Column Filtering - Multiple Values

1 Answer 32 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Raman
Top achievements
Rank 1
Raman asked on 21 Aug 2012, 01:29 PM
Hello,

      I would like to filter numeric column on multiple values. Example (OrderId = 101, 102, 103). Similar to SQL query like:
Select * from Orders where OrderId IN (101, 102, 103)

How can we achieve this in Telerik Grid.

Please advice.

Thanks.

1 Answer, 1 is accepted

Sort by
0
Martin
Telerik team
answered on 24 Aug 2012, 07:49 AM
Hello Raman,

The only built in option you can apply in this scenario is to use the Between filtering function that a numeric column supports. However, for scenarios where you want to exclude some of the values in the range (say get 101, 104 but exclude 102 and 103), you will have to apply some kind of custom filtering to your data. Here are some help articles dedicated to custom filtering options:

Custom Option for Filtering (FilterListOptions -> VaryByDataTypeAllowCustom)
Custom Filter Options with Handling

I hope this helps.

Regards,
Martin
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
Tags
Grid
Asked by
Raman
Top achievements
Rank 1
Answers by
Martin
Telerik team
Share this question
or