Select/Deselect All Filter Buttons for Multiple Data Sets

[Shri G]

Hi All,

I have a two table visualizations on separate pages with separate data tables. Some of the columns are common in both the data tables. I have managed relation between both data tables and selected Include filtered rows only as wanted to have same filtering scheme to be application on both the pages.

I have created Hierarchies for these common columns for both data tables and created filters. I have to add Select All and Deselect All buttons for this hierarchy filters. For this I have used python script. It is working for page 1 visualization but same script is not working for Page 2 visualization. I am getting below error.

Could not perform action 'Select All'.

Could not execute script 'SelectAllDates': The collection does not contain a filter with the specified name.

Script I have used :

Select All:

from Spotfire.Dxp.Application.Filters import *

from Spotfire.Dxp.Application.Visuals import VisualContent

from System import Guid

#Get the active page and filterPanel

page = Application.Document.ActivePageReference

filterPanel = page.FilterPanel

# Get the Filter

myModFilter = filterPanel.FilteringSchemeReference.DefaultFilterCollection["case open date"];

hierFilter_mod = myModFilter.As[CheckBoxHierarchyFilter]();

# Check all nodes

hierFilter_mod.CheckAllNodes()

Deselect All:

from Spotfire.Dxp.Application.Filters import *

from Spotfire.Dxp.Application.Visuals import VisualContent

from System import Guid

#Get the active page and filterPanel

page = Application.Document.ActivePageReference

filterPanel = page.FilterPanel

# Get the Filter

myModFilter = filterPanel.FilteringSchemeReference.DefaultFilterCollection["case open date"];

hierFilter_mod = myModFilter.As[CheckBoxHierarchyFilter]();

# Uncheck all nodes

hierFilter_mod.UncheckAllNodes()

Can somebody help me with this please?

Thanks!

[Fredrik Rosell]

Hello Shri,

Would it be possible for you to share the dxp file (please remove anything sensitive, just keeping enough so that the issue can be reproduced)?

[Shri G]

Hello @Fredrik Rosell​ 

I have removed all the sensitive information. It contains dates and modality only. You can use below dxp file.

[Fredrik Rosell]

Hello,

This data (information links) is linked (so it requires access to your environment to open). When saving the sample analysis, in the Data Loading Setting, use the option at the bottom to "Change all applicable data sources" to" "Stored data".

[Shri G]

Hi @Fredrik Rosell​ , sorry for this inconvenience! I am new to Spotfire I was not aware of this 😬

Please find attached updated dxp file

[Fredrik Rosell]

Hi Shri,

So do you see the issue using the embedded version that you sent? I'm afraid I don't see any issue with the latest analysis. The scripts are a bit different from what you first posted though (not using "case open date" in myModFilter = filterPanel.FilteringSchemeReference.DefaultFilterCollection["case open date"];)

I tested both SelectAllModalities and SelectAllCaseOpenDates.

This is most likely easier to troubleshoot further as a support case, so I recommend that you open a case for this in the TIBCO Support Portal - https://support.tibco.com/s/

[Informatics Consultant]

Does anyone have the solution ? I'm facing the same issue.