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 

Schedule Updates Resetting the Marking - Spotfire

Resolution

 

The problem occurs when the  "Key columns for linked data" is not set. To enable the "Key Columns for Linked Data":

1). Open the Analysis.
2). Select Edit>>Data Table Properties.
3). Select Edit>> Key columns for linked data >>Select the Key Columns
4). Click "Ok" and Save the analysis.

Hive Data source connection with Spotfire

Use JDBC connection to connect Hive database

jdbc:hive2://server.xx.net:8443/57_5383188;ssl=true;transportMode=http;httpPath=gateway/default/hive;?tez.queue.name=adhoc;

Hive commands

https://www.edureka.co/blog/hive-commands-with-examples

Executing Python Script based on Marking Selection

Suggested by Tibco

http://bispotfire.blogspot.se/2015/06/executing-python-script-based-on.html