FIlter Gridview column on another column

[Barry]

Hi 

I would like to be able to filter my gridview based on the the value of two columns.

So as an example I have a grid view containing two Amount columns and I'd like to implement filtering so that they could filter the results based on any one of the following criteria: 

• Amount 1 > Amount 2
• Amount 2 > Amount 1
• Amount 1 = Amount 2

Is this possible to do?  I am using 2009 Q2 and am unable to upgrade to the latest version.

Thanks

[Julian Benkov]

Hi Barry,

This functionality cannot be achieved directly by a FilterDescriptor object. First, you must calculate the value of the desired column and then use this value to add a FilterDescriptor. Here is a sample code snippet:

private void radButton1_Click(object sender, EventArgs e)
{
    this.radGridView1.EnableFiltering = true;

    object val = this.radGridView1.Evaluate("Max(Amount2)", this.radGridView1.Rows);
    this.radGridView1.FilterDescriptors.Add(new FilterDescriptor("Amount1", FilterOperator.IsGreaterThan, val));
}

You can also achieve the desired behavior by using the custom filtering mode that RadGridView provides.
Please review the examples of this mode in our Examples application, section RadGridView >> Filtering.

Regards,
Julian Benkov
the Telerik team