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