RadGridView custom filter operator

Hello, Joar,  

RadGridView offers a flexible public API for custom filtering which allows you to fully control the filtering logic. Additional information is available in the following help article: https://docs.telerik.com/devtools/winforms/controls/gridview/filtering/custom-filtering

You can also refer to our Demo application >> GridView >> Filtering >> Custom Filtering example which is quite useful on this topic.

As to the question about adding a custom filter option in the filter menu, you can handle the ContextMenuOpening event and add a new RadMenuItem. When the item is clicked, you can add the desired FilterDescriptor programmatically. A sample code snippet is illustrated below. Note that this is just a sample approach and it may not cover all possible cases. Feel free to modify it in a way which suits your requirement best: 


Note that you can also use the Custom option in the filter menu to build a more complex filter expression.

I hope this information helps. If you need any further assistance please don't hesitate to contact me. 

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik

This was almost all that I needed. In addition to the described solution from you, I subscribed to the tasksGridView.FilterExpressionChanged event to empty out the default filter operator stuff, and updated the custom filtering that is used in tasksGridView.CustomFiltering event with info from the tasksGridView.FilterChanging event. When wanting to use the default filters, I just dont empty the 

 

Thank you for the support!

Regard,

Joar

Hello, Joar,   

I am glad that the suggested solution was suitable for your case. However, have in mind that if the custom filtering is enabled it is not necessary to remove any FilterDescriptor from the FilterDescriptors collection. The custom filtering behavior has a higher priority than the default filter and although the filtering UI is indicated in the same way, the CustomFiltering event controls how the rows will be filtered. If you set the Handled argument to true, you need to specify whether the row will be visible or not by the Visible argument in the GridViewCustomFilteringEventArgs.

In order to determine more easily whether a row is visible or not in the CustomFiltering event when the grid is filtered by several columns, you can use the MasterTemplate.DataView.FilterEvaluate method. This method accepts a FilterDescriptor and a row as parameters and returns a boolean value indicating whether the row will be visible or not according to the passed FilterDescriptor. Thus, you can combine the custom logic for a certain column and evaluate the default one for the rest of the column's filters.

Please refer to the following help article which demonstrates how the custom filtering works: https://docs.telerik.com/devtools/winforms/controls/gridview/filtering/custom-filtering

I hope this information helps. If you need any further assistance please don't hesitate to contact me. 

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik

Hi Dear !

I have a radGridView that have an CustomFilter in design time .

But at runtime when user add new row or change existing rows that not match with filter. Filter event does not fired and radGridView rows not filterd.

please see following code snippet :

    this.radGridView1.MasterTemplate.EnableCustomFiltering = true;
      this.radGridView1.CustomFiltering +=
                new GridViewCustomFilteringEventHandler(radGridView_CustomFiltering);

 private void radGridView1_CustomFiltering(object sender, GridViewCustomFilteringEventArgs e)
        {
            e.Visible = (EntityState)e.Row.Cells["EntityState"].Value != EntityState.Deleted;
        }

 

Hello, Reza,

In the CustomFiltering event there is an argument which is called Handled. It defines whether the row is processed by the custom algorithm or by the applied filter descriptors. If it is set to true, the Visible argument will take effect.

Additional information about how the custom filtering works is available in the following help article: https://docs.telerik.com/devtools/winforms/controls/gridview/filtering/custom-filtering 

You can also have a look at our Demo application >> GridView >> Filtering >> Custom Filtering example.

I hope this information helps. 

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik