test

Warning when upgrading to Spotfire 10

TIBCO has deprecated the JQueryUI Javascript library in the latest Spotfire 10.0 release

TIBCO Community pages show us how to use JQuery properly

Create TablePlot and Add columns

#######################################
# Creates or updates a tablePlot with #
# columns selected from a multiselect #
# doc prop control                    #
# Author: Jose Leviaguirre  Aug 2015  #
#######################################

from Spotfire.Dxp.Application.Visuals import TablePlot, VisualContent
from Spotfire.Dxp.Data import DataPropertyClass

#Script Parameters/Settings
multiSelectColumnsPropertyControl = "selectedTablePlotColumns" #multiselect doc prop control
#dataTable = Document.Data.Tables["yourTable"] #reference to a specific data table
dataTable = Document.Data.Tables.DefaultTableReference #reference to the default data table

# 1 Create a table if not there already
tablePlotVisual = None
updateTablePlot = False
defaultTableTitle=dataTable.Name

# 1.1 check if tablePlot already exist (based on name)
for v in Document.ActivePageReference.Visuals: 
   tablePlotVisual = v
   updateTablePlot = v.Title == defaultTableTitle
   if v.Title == defaultTableTitle: break

# 2.1 If no tablePlot found, create a new one
if not updateTablePlot:
tablePlotVisual = Application.Document.ActivePageReference.Visuals.AddNew[TablePlot]()
tablePlotVisual.Data.DataTableReference = dataTable
tablePlotVisual.Title = "${DataTable.DisplayName}"
tablePlotVisual.Legend.Visible= False
else:
tablePlotVisual=tablePlotVisual.As[VisualContent]()


# 2 Adds columns to a Data Table based on a document property. 
# The doc prop is a comma separated list of columns for the data table to show.
# use a multiline doc prop control to create a csv list of cols

# 2.1 Remove all columns
cols = tablePlotVisual.Data.DataTableReference.Columns
tablePlotVisual.TableColumns.Clear()

# 2.2 get document property
selection = Document.Data.Properties.GetProperty(DataPropertyClass.Document, multiSelectColumnsPropertyControl).Value

# 2.3 Parse columns from selection and add to tablePlotVisual
for property in selection:
   for col in property.split(","): tablePlotVisual.TableColumns.Add(cols[str(col)])



No comments: