Filtering multiple columns with or

[Dev]

I was wondering if the grid view do a complex or statement between multiple columns.. I basically want the following statement.

var_1 = 1234

Show me all rows where (column_1 contains var_1 ) or (column_2 contains var_1 ) or (column_3 contains var_1 ) or (column_4 contains var_1 )

So I can have 1 field that searches multiple columns... can this be done with the radGridView or does it have to be done server side? Any sample code would be greatly appreciated.

[Julian Benkov]

Hi Jim,

You can add more filter expressions to handle this scenario:

this.radGridView1.MasterGridViewTemplate.FilterExpressions.Add(
    new Telerik.WinControls.Data.FilterExpression("ContactName", Telerik.WinControls.Data.FilterExpression.BinaryOperation.OR,GridKnownFunction.Contains, var_1));
this.radGridView1.MasterGridViewTemplate.FilterExpressions.Add(
   new Telerik.WinControls.Data.FilterExpression("Address", Telerik.WinControls.Data.FilterExpression.BinaryOperation.OR, GridKnownFunction.Contains, var_1));
this.radGridView1.MasterGridViewTemplate.FilterExpressions.Add(
   new Telerik.WinControls.Data.FilterExpression("Region", Telerik.WinControls.Data.FilterExpression.BinaryOperation.OR, GridKnownFunction.Contains, var_1));

If you have additional questions, feel free to contact me.

Sincerely yours,
Julian Benkov
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Dev]

Thanks for the help.