How to change Filter Bar Query ?

[Administrator]

1. Can I default FilterRow query to use CONTAINS instead of LIKE ?

2. Can I change FilterRow query to use OR instead of AND ?

[Administrator]

Hi,

You would have to derive the Filterbar and override this method:

public class MyGridFilterBar : GridFilterBar
{
protected override string GetFilterFromRow(GridDataBoundGrid grid)
{
string filter = base.GetFilterFromRow(grid);
filter = filter.Replace("LIKE", "CONTAINS");
filter = filter.Replace("AND","OR");
retrun filter;
}
}

Let me know if this helps.
Best Regards,
Haneef