Excel Like Filtering

[Sudeep]

hi all

Is there a way to display the distinct values calculated after each column is filtered and I only want the value that still remain in the view?

[Richard Slade]

Hello Sudeep,

If my understanding of your issue is correct, you have a RadgridView, which you you both standard and excel like filtering on. If you type something into the standard filter, you are not seeing this reflected in the excel like filter. Is that correct?

If so, I have tried this with the latest Q3 2010 SP1 version and could not replicate your issue. In a GridViewDecimalColumn, I had several integer values. I added the following code

this.radGridView1.EnableFiltering = true;
this.radGridView1.ShowFilteringRow = true;
this.radGridView1.ShowHeaderCellButtons = true;

And then I set the standard filter, by typing into the filter area 1. After clicking the excel like filter button, I saw this was reflected in the criteria. Please see the attached screenshots.

If you are not on the latest version, i'd suggest upgrading. If you are, then please post a sample that replicates this and I'll take a look at it for you
Thanks
Richard

[Sudeep]

Hello Richard
After i use a filter on 'MID' column in my grid, i sholud see only those 'TID' which are associted with the MID as displayed on the grid.
But my filter contains all the 'TID's which were loaded initially in the grid.
How to get rid of this?

[Richard Slade]

Hello Sudeep,

As far as I know that isn't supported. When you perform an equals filter by typing into a filter, it can search through the values in that column and sets the appropriate checkboxes in the excel like filter. But my guess is, that if it had to do this for every row, and then for every column performance would start to suffer. Because you have only chosen to filter by one column, the other filters are unaffected.
Regards,
Richard

[Martin Vasilev]

Hello guys,

Actually, Sudeep has a valid point here and we are considering to include this functionality: to filter the values in Excel-Like filtering popup, according to the applied filtering on other columns. We will include this in one of the next releases, however I cannot give a time frame for this yet.

Kind regards,
Martin Vasilev
the Telerik team

[Sandi Markon]

Hello everybody,

Has any progress been made regarding this issue? Or maybe there's a convenient workaround for this?

I'm thiking, if there would be an event, which fires evertime, the excel-like filtering dialog is popped up, then I could programatically pick up the currently displayed column values (by use of the ChildRows property) and fill the filter dialog with the filtered values.

Thanks in advance,
S

[Jack]

Hi Sandi Markon,

This feature is still not in our plans. However, I added it in our public issue tracking system. This way you and the other users can vote for it and if there is high interest in it, we will consider raising its priority. Use the following link to vote for this feature. 

Meanwhile, there is an event which you can use to manually check the desired nodes for the desired columns. Attached you can find a sample implementation.

Let us know if you have any other questions.
 
Regards,
Jack
the Telerik team