[Solved] Multiple columns 'OR' Filtering

[Fernando]

Hi!

Isn't this suposed to work?

protected void uxGridSubscription_OnItemCommand(object sender, GridCommandEventArgs e)

{

    if (e.CommandName == RadGrid.FilterCommandName)

    {

        var filterPair = (Pair) e.CommandArgument;

 

        switch (filterPair.Second.ToString())

        {

             

 

            case "Name":

                {

                    var filterValue = uxGridSubscription.MasterTableView.GetColumnSafe("Name").CurrentFilterValue;

                    uxGridSubscription.MasterTableView.FilterExpression = "(([Name] LIKE \'%" + filterValue + "%\') OR ([Obs] LIKE \'%" + filterValue + "%\'))";

 

                    var column2 = uxGridSubscription.MasterTableView.GetColumnSafe("Obs");

                    column2.CurrentFilterFunction = GridKnownFunction.Contains;

                    column2.CurrentFilterValue = filterValue;

                    uxGridSubscription.MasterTableView.Rebind();

                    break;

                }
     }

    }

}

This acts like 'AND' and not an 'OR'. 

Best Regards, Fernando Moreira

[Andrey]

Hello,

You could try to place this logic inside the PreRender event of RadGrid and check whether you get the desired behavior.

bool nameFiltered = false;
protected void uxGridSubscription_ItemCommand(object sender, GridCommandEventArgs e)
{
    if (e.CommandName == RadGrid.FilterCommandName)
{
    var filterPair = (Pair) e.CommandArgument;

    switch (filterPair.Second.ToString())
    {
        case "Name":
            {
                nameFiltered=true;
            }
            break;
    }

}

protected void uxGridSubscription_PreRender(object sender, EventArgs e)
{
    if(nameFiltered)
    {
    var filterValue = uxGridSubscription.MasterTableView.GetColumnSafe("Name").CurrentFilterValue;
    uxGridSubscription.MasterTableView.FilterExpression = "(([Name] LIKE \'%" + filterValue + "%\') OR ([Obs] LIKE \'%" + filterValue + "%\'))";

    var column2 = uxGridSubscription.MasterTableView.GetColumnSafe("Obs");
    column2.CurrentFilterFunction = GridKnownFunction.Contains;
    column2.CurrentFilterValue = filterValue;
    uxGridSubscription.MasterTableView.Rebind();
    }
}

Regards,
Andrey
the Telerik team