[Solved] dropdown Filter on multiple values

[Jay]

Hi,

I have implemented a dropdown filter for the status column in the grid displaying requests
there are 5 status values. 

New
Open
In-Process
Resolved
Closed

I am able to filter the grid based on the drop down by selected one of the above values using the following code

protected void cbStatusFilter_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
       {
           GridFilteringItem filterItem = (GridFilteringItem)grdRequests.MasterTableView.GetItems(GridItemType.FilteringItem)[0];
           Status = e.Value;
           (filterItem.FindControl("txtStatus") as TextBox).Text = e.Value;
           if (e.Value != "")
           {
               filterItem.FireCommandEvent("Filter", new Pair("EqualTo", "Status"));
           }
           else
               filterItem.FireCommandEvent("Filter", new Pair("NoFilter", "Status"));
       }

           private string Status
       {
           get
           {
               if (ViewState["Status"] == null)
                   return "";
               else
                   return ViewState["Status"].ToString();
           }
           set { ViewState["Status"] = value; }
       }

 What I want to be able to do is add an additional value in the dropdown called Unresolved which when selected should show requests with New, Open, and In-Process status. I am not sure how to go about implementing this.



How do I call the FireCommandEvent to filter by multiple values i.e New, Open, In-Process
thanks

[Veli]

Hi Jay,

To implement filtering by multiple values in a single field, you need to set a custom FilterExpression to the MasterTableView (or the table you are filtering). You can refer to the RadGrid FilterExpression property API on how to set the FilterExpression in a proper format.

Veli
the Telerik team