Filter mulitiple columns

[Mattias Kristoffersen]

Hi!

I have a case where i want to filter muliple columns with "contains".
Lets say i have a  textbox with the following value:

"manual gearbox Volvo"

I would like to filter all columns that contains either

manual
or Gearbox
or Volvo

i cant get this to work. Any ideas?


This is my code:

if (RadTextBox1.Text != "")
                {



                    string[] words = RadTextBox1.Text.Split(' ');
                    foreach (string word in words)
                    {
                        RadListViewContainsFilterExpression expressionFree = new RadListViewContainsFilterExpression("info");
                        RadListViewContainsFilterExpression expressionFree1 = new RadListViewContainsFilterExpression("brand");
                        RadListViewContainsFilterExpression expressionFree2 = new RadListViewContainsFilterExpression("model");

                        expressionFree.CurrentValue = word;
                        RadListView1.FilterExpressions.Add(expressionFree);

                        expressionFree1.CurrentValue = word;
                        RadListView1.FilterExpressions.Add(expressionFree1);

                        expressionFree2.CurrentValue = word;
                        RadListView1.FilterExpressions.Add(expressionFree2);
                    }

                }
                RadListView1.Rebind();

[Mattias Kristoffersen]

i think i solved it

string[] words = RadTextBox1.Text.Split(' ');
                  foreach (string word in words)
                  {

                  RadListView1.FilterExpressions.Add(
                     new RadListViewGroupFilterExpression(RadListViewGroupFilterOperator.Or)
                     {
                         Expressions =
                         {
                             new RadListViewContainsFilterExpression("info"){CurrentValue  =  word},
                             new RadListViewContainsFilterExpression("brand"){CurrentValue  =  word},
                             new RadListViewContainsFilterExpression("modeldescription"){CurrentValue  =  word},
                             new RadListViewContainsFilterExpression("bodytype"){CurrentValue  =  word},
                             new RadListViewContainsFilterExpression("city"){CurrentValue  =  word},
                             new RadListViewContainsFilterExpression("color"){CurrentValue  =  word},
                             new RadListViewContainsFilterExpression("regno"){CurrentValue  =  word},
                             new RadListViewContainsFilterExpression("model"){CurrentValue  =  word}
                         }
                     }
                 );
                 }