Thank you for your reply,
Probably I was not clear enought in my question and I am sorry for that.
The question is, in the filterbar of the grid, the customer wants to write "car+blue" and the grid automaticly filter that column to values wich have both words, like "Blue Car of Brand Y".
Meanwhile I grabed my big hammer and came out with this amazing solution :)
And It actualy works!
if (dm.Where != null && dm.Where.Count > 0) //Filtering
{
dm.Where.ForEach(f => f.Operator = "contains");
List<WhereFilter> filters = new List<WhereFilter>();
for (int i = 0; i < dm.Where.Count; i++)
{
if(dm.Where[i].value!=null && dm.Where[i].value.ToString().Contains("+"))
{
var items = dm.Where[i].value.ToString().Split('+');
foreach (var item in items) {
filters.Add(new WhereFilter() {
Condition = dm.Where[i].Condition,
Field = dm.Where[i].Field,
IgnoreCase = dm.Where[i].IgnoreCase,
IsComplex = dm.Where[i].IsComplex,
Operator = dm.Where[i].Operator,
predicates = dm.Where[i].predicates,
value = item
});
}
}
else
{
filters.Add(dm.Where[i]);
}
}
dm.Where = filters;
result.result = operation.PerformWhereFilter(result.result, dm.Where, "contains");
result.count = result.result.Cast<QuoteLineMaterial>().Count();
}
