RadPivotGrid Filter Values on Code

[Jose]

Hi

I am using IE 11 and the controls' version is 2013.2.717.35. My project is on C# and I use Visual Studio 2010.

I have a Pivot Grid control with PivotGridReportFilterField fields. How do I access on the server code, for example on the item command event, the filter values the user might have selected for each PivotGridReportFilterField fields? I need this information for a particular case on my application to filter another query.

Please provide me a sample code.

Note: I found this link - http://www.telerik.com/help/aspnet-ajax/grid-gridtableview-get-filterexpressions.html

It seems to be what I need for the case of a grid but I could not apply the suggestions to my pivot grid.

Thanks in advance,

Jose

[Vasil]

Hi Jose,

The RadPivotGrid does not provide way for accessing the filter expressions as in the RadGrid, because if it's more complex way of internal filtering. The closest thing is to use IQueryable as DataSource and use it's Expression.
Another option is to use the FilterWindow property of the PivotGrid to get the filtering window, and then the SetBox property of this window to access the RadListBox that holds filter values that can be checked.

Regards,
Vasil
Telerik