Change "Filtering in Related Data Tables" for multiple Filtering Schemes

[Sander Koster]

Hi,

I am looking for a script which changes the filtering in related data tables from "Exclude Filtered Out Rows" to "Include Filtered Out Rows" for multiple filtering schemes. At this moment I have a script (see below) which only changes the settings for the Active Filtering Scheme. Please help!

Thanks! Sander

 

#Set Correct Filter Relations For All Filtering Schemes

from Spotfire.Dxp.Data import DataFilteringSelection, RelatedRowsPropagation

from Spotfire.Dxp.Application.Filters import FilteringSchemeCollection

from Spotfire.Dxp.Application.Filters import FilteringScheme

from Spotfire.Dxp.Application.Filters import FilterCollection

toTable=Document.Data.Tables["Forecast Data"]

fromTable=Document.Data.Tables["DailyRevAndSales"]

DataFilteringSelection=Document.ActiveFilteringSelectionReference

DataFilteringSelection.SetRelationPropagationBehavior(toTable,fromTable,RelatedRowsPropagation.OnlyMatching)

[Shandilya Peddi]

You can use the below snippet to choose the Filtering Scheme

FilterSelection = Document.Data.Filterings["Filtering scheme"]