Nov 2, 2015

Assign marked values to Porperty control and redirect to new page

from Spotfire.Dxp.Data import DataValueCursor
myLatCursor = DataValueCursor.CreateFormatted(Document.Data.Tables["IL_GetStatus"].Columns["Project_ID"])
markedRows = Document.Data.Markings["StatusReportMarking"].GetSelection(Document.Data.Tables["IL_GetStatus"]).AsIndexSet()
for row in Document.Data.Tables["IL_GetStatus"].GetRows(markedRows, myLatCursor):
 Document.Properties['JobID'] = myLatCursor.CurrentValue
 Document.ActivePageReference = Document.Pages[2]

Jun 15, 2015

Toggle the filter panel on\off

if (Document.ActivePageReference.FilterPanel.Visible == False):
   Document.ActivePageReference.FilterPanel.Visible = True
else:
   Document.ActivePageReference.FilterPanel.Visible = False

Toggle the details-on-demand panel on\off

if (Document.ActivePageReference.DetailsOnDemandPanel.Visible == False):
   Document.ActivePageReference.DetailsOnDemandPanel.Visible = True
else:
   Document.ActivePageReference.DetailsOnDemandPanel.Visible = False

Mar 4, 2015

Assingn table filtered value to parameter from column in Spotfire using python script

import Spotfire.Dxp.Data.DataTable
from Spotfire.Dxp.Data import *
from Spotfire.Dxp.Data import DataValueCursor
dataTable = Document.ActiveDataTableReference
rows = Document.ActiveFilteringSelectionReference.GetSelection(dataTable).AsIndexSet()
for row in rows:
 for column in dataTable.Columns:
  if (column.Name == 'Analysis_Jobs_ID'):
   Document.Properties.Item["Jobid"]=(column.RowValues.GetFormattedValue(row))






----------------------------
Jobid is a parameter





Feb 18, 2015

Page navigation with pything script on spotfire

Document.ActivePageReference = Document.Pages[8];
Document.Properties.Item["pagenumber"]=7