Jump to content
We've recently updated our Privacy Statement, available here. ×

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


Sander Koster

Recommended Posts

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)

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...