FilteredGroups in RadPivotGrid

3 Answers 33 Views
PivotGrid
Jose Antonio
Top achievements
Rank 1
Iron
Jose Antonio asked on 16 Jul 2021, 11:19 AM | edited on 16 Jul 2021, 11:22 AM

 

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

 

3 Answers, 1 is accepted

Sort by
0
Dilyan Traykov
Telerik team
answered on 21 Jul 2021, 08:10 AM

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

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

Jose Antonio
Top achievements
Rank 1
Iron
commented on 21 Jul 2021, 09:48 AM

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
Telerik team
commented on 23 Jul 2021, 01:03 PM

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
Top achievements
Rank 1
Iron
commented on 23 Jul 2021, 02:01 PM

Hello Dylan, i reply an answer with images to try explain our requirements
0
Jose Antonio
Top achievements
Rank 1
Iron
answered on 23 Jul 2021, 02:00 PM

Hello Dyllan,

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

Regards

 

JAGA

0
Vladimir Stoyanov
Telerik team
answered on 28 Jul 2021, 11:37 AM

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

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

Jose Antonio
Top achievements
Rank 1
Iron
commented on 03 Aug 2021, 07:05 AM

Hi Vladimir

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

Regards

JAGA

Tags
PivotGrid
Asked by
Jose Antonio
Top achievements
Rank 1
Iron
Answers by
Dilyan Traykov
Telerik team
Jose Antonio
Top achievements
Rank 1
Iron
Vladimir Stoyanov
Telerik team
Share this question
or