FilteredGroups in RadPivotGrid

[Jose Antonio]

 

Mornings,

When we set a "contains" filter with fieldlist we need to know which rows are excluded by it. We have seen that the FilteredGroups property exists but it is not accessible.

Is there any way to find these filtered elements? 

Are there any events that can be intercepted in the filtering action itself?

Library vVersion: 2017.1.117.45

Thanks for everything

Regards

 

[Dilyan Traykov]

Hello Jose,

Indeed, it appears that the FilteredGroups property is currently not accessible.

You can, however, access it via reflection, like so:

            var provider = sender as LocalDataSourceProvider;
            var results = provider.GetType().GetProperty("Results", System.Reflection.BindingFlags.NonPublic | System.Reflection.BindingFlags.Instance).GetValue(provider, null);
            var filteredGroups = results.GetType().GetProperty("FilteredGroups", System.Reflection.BindingFlags.Public | System.Reflection.BindingFlags.Instance).GetValue(results, null);

If this is indeed the property you require, we can consider exposing it in future releases. Please let me know if this is indeed the case.

Regards,
Dilyan Traykov
Progress Telerik

[Jose Antonio]

Hello Dilyan,

First of all, thanks for your reply

I can access it correctrly but how can access to item DataContext property ?

Regards

[Dilyan Traykov]

Hello Jose,
Would you find it possible to elaborate more on your exact requirement as I could not infer this from your previous comment? To which item do you want to gain access? Can you please share some concrete examples, possibly with some visual representation so that we can avoid any misunderstandings?
Thank you in advance for your cooperation on the matter.

[Jose Antonio]

Hello Dylan, i reply an answer with images to try explain our requirements

[Jose Antonio]

Hello Dyllan,

Thanks for all, i try to explain with pictures,  our funcional requirements 

Regards

 

JAGA

[Vladimir Stoyanov]

Hello Jose,

Thank you for the attached pictures. 

Can you check out the Drill Down functionality of the RadPivotGrid? It allows you to extract the records from your ItemsSource that were used for accumulating the result for a particular row and column. The extracted items will be without the ones that are filtered out by the label filter. You can check out the example from the linked article, which demonstrates how to take advantage of this method upon a double-click. 

I hope you find this helpful.

Regards,
Vladimir Stoyanov
Progress Telerik

[Jose Antonio]

Hi Vladimir

Thanks for all, the solution is correct, perfect for me and solves our problem correctly

Regards

JAGA