Get selected filter menu value

[Eric]

I need to know how to get to the selected value of the filter menu. For example if the user selects "Contains" from the menu, I need to know where to get to the value "Contains".

When I try to get it from column.CurrentFilterFunction, I get an empty string. I was assuming that the CurrentFilterFunction property was what I was looking for, but I guess not.

Is there a way to get this value programmatically?

Thanks,
Eric

[Shinu]

Hello Eric,

Try accessing the filter menu in ItemCommand event as shown below.
C#:

protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
 if (e.CommandName == RadGrid.FilterCommandName)
 {
   Pair filterPair = (Pair)e.CommandArgument;
   string value = filterPair.First.ToString();
 }
}

Thanks,
Shinu.

[Eric]

Thank you for your reply, Shinu. I should have mentioned that I had already explored that, but during that event, the filters come through one at a time, which does not work for our needs.

I am trying to loop through the columns and extract it that way to aggregate the filters and associated values, to build a custom where clause for a stored procedure. I'm trying to avoid working with the FilterExpression manually.

Any idea how to best attack this situation - my first time with the RadGrid.

Thanks,
Eric

[Antonio Stoilkov]

Hi Eric,

You could achieve your scenario by subscribing to RadGrid PreRender event and access the MasterTableView FilterExpression there and implementing your logic. You could take a look at the help articles below for more information on the topic.

• http://www.telerik.com/help/aspnet-ajax/grid-applying-default-filter-on-initial-load.html
• http://www.telerik.com/help/aspnet-ajax/grid-operate-with-filter-expression-manually.html

All the best,
Antonio Stoilkov
the Telerik team