RadGrid Filter like NotIn Operator

[Rakesh]

Dear,

I am using Radgrid and I have a requirement to filter record in Grid like we do "NOT IN" Query in SQL Server.
I have a scenario like this:

I place RadCombobox in Grid' FilterTemplateColumn with respected filter values.
There are four values i.e. Value1, Value2, Value3 and Other. I fetch the data from Status table, which has status values like Value1, Value2, Value3 and Rest of the other status as Other.
For Value1, 2 and 3 I am using code like this:
and it is working fine.
tableView.filter("STATUSNAME", args.get_item().get_value(), "EqualTo");

My requirement is for fourth filter value "OTHER". When user selects "OTHER" I want to filter records which are NOT IN Value1, Value2 and Value3.


Thanks in advance.

[Mira]

Hello Rakesh,

I have followed your scenario and prepared a sample project for you demonstrating how the desired functionality can be implemented. You can find it attached to this message.

I hope it helps.

Greetings,
Mira
the Telerik team