How to Remove Unreferenced Filtering Schemes in an Analysis in Spotfire® Using IronPython Scripting

Introduction

Below is a sample script to remove any Filtering Schemes available in the analysis which are not referenced by any visualizations.

Code Sample

# Copyright © 2017. TIBCO Software Inc. Licensed under TIBCO BSD-style license.

from Spotfire.Dxp.Application.Visuals import *
from System.Collections.Generic import List
listofFilteringSchemes=set()

for page in Document.Pages:
	for vis in page.Visuals:
		if str(vis.TypeId) != "TypeIdentifier:Spotfire.HtmlTextArea":
			visData= vis.As[VisualContent]().Data
			if visData.UseActiveFiltering:
				fs=page.ActiveFilteringSelectionReference.Name
				listofFilteringSchemes.add(fs)
			if visData.Filterings.Count!=0:
				for i in visData.Filterings:
					listofFilteringSchemes.add(i.Name)

for i in Document.FilteringSchemes:
	name=i.FilteringSelectionReference.Name
	if name not in listofFilteringSchemes:
		Document.Data.Filterings.Remove(i.FilteringSelectionReference )

References

• API Reference: VisualizationData
• API Reference: DataManager
• API Reference: DataManager.Filterings

License:  TIBCO BSD-Style License

Back to IronPython Scripting in Spotfire Examples:  https://community.spotfire.com/s/article/IronPython-Scripting-in-Spotfire