How to get all the values of the ListBoxFilter using IronPython

[Laxmi Acharya]

Hi,

I want to get all the values of the ListBoxFilter without iterating through the rows of column using ironpython

Reference:

https://community.spotfire.com/questions/need-help-how-assign-selected-valu...

here in the above link source code - have iterated through the column values

but instead i want all the unique values through filter only.

Thanks.

[Rayees Wani]

Check below two options:

1. https://community.spotfire.com/questions/how-can-get-values-list-box-filter...

2.

######################################################################

from Spotfire.Dxp.Application.Visuals import VisualContent

from Spotfire.Dxp.Application import Filters as filters

from Spotfire.Dxp.Application.Filters import FilterTypeIdentifiers

out=""

# Get the filter panel on the current active page

filterPanel = Document.ActivePageReference.FilterPanel

# Perform filtering action

for tableGroup in filterPanel.TableGroups:

for fh in tableGroup.FilterHandles:

if fh.Visible:

if (fh.FilterReference.TypeId == FilterTypeIdentifiers.ListBoxFilter):

cbFilter = fh.FilterReference.As[filters.ListBoxFilter]()

for checkedValues in cbFilter.SelectedValues:

out+=checkedValues+"n"

Document.Properties["Debug"] = out

######################################################################

[Laxmi Acharya]

here, print cbFilter #gives me ColumnName : ((All))in my case i don't have any filtered rows so on doing 

 

print out #prints a blank string here

 

because it doesn't go inside the for loop i.e.

for checkedValues in cbFilter.SelectedValues:

     .....Thanks