How to Reset All Filters For All Filtering Schemes in Spotfire® Using IronPython Scripting

#Please note, some of the URLs in this article may be out of date due to the Spotfire Community migration [Dec 23]

Introduction

The built-in Action Control function of 'Reset All Filters' will reset all filters in the current Filtering Scheme only. In order to reset all filters in all filtering schemes in the document, you can use this example IronPython script.

Code sample

 # Copyright © 2017. TIBCO Software Inc.  Licensed under TIBCO BSD-style license.  
 
 from Spotfire.Dxp.Data import * 
 from Spotfire.Dxp.Application.Filters import *  
 
 def resetAllFilteringSchemes():
 # Loop through all filtering schemes      
 for filteringScheme in Document.FilteringSchemes:           
 # Loop through all data tables           
 for dataTable in Document.Data.Tables:                
 # Reset all filters                
 filteringScheme[dataTable].ResetAllFilters()						  
 
 # Call the function 
 resetAllFilteringSchemes()

References

• API Reference: FilteringSchemes Property
• API Reference: ResetAllFilters Method

License:  TIBCO BSD-Style License

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