May 11, 2017

Get and set filter value in Spotfire using python script

import Spotfire.Dxp.Application.Filters as filters
import Spotfire.Dxp.Application.Filters.ListBoxFilter
from Spotfire.Dxp.Application.Filters import FilterTypeIdentifiers
from Spotfire.Dxp.Data import *
from Spotfire.Dxp.Application.Filters import *
finalStr = ""
filt=Document.FilteringSchemes[0][myTable][myTable.Columns["Control Name"]].As[ListBoxFilter]()
strVals=''

for value in filt.SelectedValues:
  strVals=strVals+value+',';

finalStr =strVals.strip(',')

myPanel=Application.Document.ActivePageReference.FilterPanel
myFilter=myPanel.TableGroups[1].GetFilter("Control Name")
myFilter.FilterReference.As[ListBoxFilter]().Reset()
myFilter.FilterReference.As[ListBoxFilter]().IncludeAllValues = False
myFilter.FilterReference.As[ListBoxFilter]().SetSelection(finalStr.split(','))


-myTable = Variable