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.
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
0
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
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.