Filter Dialog in RadGridView

[Peter]

I would like to set the filter of a particular column of my RadGridView automatically after the grid is loaded with data.
However, I could not get the instance of the Filter Dialog and set it. How can I do that?

Currently I programmatically insert a ColumnFilterDescriptor into the RadGridView with the specified column
and set the filtering to what I wanted it to filter.

This will actually set the Filter Dialog however it does not do the filtering unless I Click the Filter button or make any
changes to the Filter Dialog that will trigger the reloading of the data. 

Please help me, many thanks

[Maya]

Hi Peter,

May you provide a bit more details about the exact behavior you want to accomplish ? Do you want to pre-filter the grid as in this article ? Why do you want to access the filter dialog ? Generally, you need to work with the FilterDescriptors/ ColumnFilterDescriptors of the grid. 

 

Best wishes,
Maya
the Telerik team

[Peter]

Hi,

I used a QueryableDomainServiceCollectionView  in the ViewMdoel and let myRadGridView.ItemsSource binding to the ViewModel. I would like to pre-set the filter at the UI side so when the data is loaded, it displayed filtered results.By pre-set the filter, I mean  I would like to pre-set the filter for a particular column that I want to filter in the RadGridView.

I did tried to add ColumnFilterDescriptor to the RadGridView by doing something like this:

ColumnFilterDescriptor cfd = new ColumnFilterDescriptor(column);
myGridView.FilterDescriptors.Add(cfd);

I inserted the above code in RadGridView's Loaded event handler.
This actually changes the UI of the Grid (the funnel icon of the column changes to orange color, and the filter dialog has the value that I set. However, It does not update the data in the RadGridView, that is the data presented are the data before applying the filter. It doesn't seem to trigger the filter.

How can I trigger the filter to filter the data?

Thanks a lot.

[Rossen Hristov]

Hi Peter,

Please, read my blog post, in case you have not.

You have to make sure that the QDSCV is AutoLoa=true, bind the RadGridView.ItemsSource to the QDSCV and then add the ColumnFilterDescriptor to the grid.

This is the same as the end user opening the filtering UI and clicking on a value.

I hope this helps. Let me know if there are problems.

Best wishes,
Ross
the Telerik team