Solution Runner

1

TIService configuration

• ProcessMasterSolutionName = "AdminScripts"
• SolutionRunnerExtendedLog = true/false

2

TIS Table for scripts

• TIS\$SysTables\AdminScripts

Event

Refer to a script in event definition

Data source

Use solution runner as a data source for a portlet

 Note syntax {BP:}<scriptname>{:EP}

 Note that the portlet has be saved before a solution runner can be specified.

Cron job

Tabletype

string

unique name of a script

Solution

string

project name

B/D

integer

per solution unique integer

Datanode

string

data node name

NewParent

string

ConnString

string

Select/Values

string

Where/Keys

string

OrderBy

string

Action

string

action identifier see list below

Targettable

string

Order

integer

unique order number per script

Comment

string

SQL

Statement fuer SQL-Operator zusammenbauen

ClearActionTable

SetLongRunning

indicates that this solution runner should continue even if the starting user logges off

Parent

Elternknoten umhaengen fuer Datenknoten

DB_Update

Update fuer Datenknoten aufrufen Werte ersetzen

DB_UpdateAdd

Update fuer Datenknoten aufrufen Werte addieren

DB_Del

Delete CUD aufrufen

TISSolution

TIS Solution oeffnen/holen und durchrechnen

Gentable

Resulttable des Knotens setzen

ClearResults

Ergebnistabellen disposen

BreakNoData

Solutionrunner abbrechnen wenn keine Daten vorhanden

NoDataGoto

GoTo

GotoTag

Einspringpunkt

PRead

Peristenztabelle lesen Einstellungen Operator

Recalculate

Datenknoten neu rechnen

RecalcReport

Datenknoten neu rechnen inkl. Klonen Resulttabelle

SolutionRunner as data source of a portlet, there must be this action as final step.

SetParam

Sets the value of a TIS Parameter.

Note: affected data nodes are not set dirty

• Datanode: Parameter name
• Targettable: Parameter value

SetTimezone

Parameter

ParamRecalc

Controller Portlet (MetaData)

AddScript

• Datanode: #XI.Add
• Targettable: TableType of sub-routine

ErrorInfoCollect

ErrorInfoDBClear

ErrorInfoDBWrite

Writes to IQMetrixErrorCodeRecord (t6003).

RecalcTISChart

Datenknoten neu rechnen inkl. TISChartInfo

RecalcEJSChart

Datenknoten neu rechnen inkl. EJSChartInfo

DB_RangeDel

Löschen mittels DELETE Statement

OpInstruction

FileGuard

Führt eine OpInstruktion auf der Operation aus.

SetImportFileName

FileGuard

• Targettable: 0 (position in string)

SetExportFileName

FileGuard

DeleteFileName

FileGuard

Delete a TIS File.

SetLocalParam

Sets a local parameter to a specified (constant) value

CheckAccessTISTable

Checks if accountname and password match to entries in a tistable

StopIf

Stops if the value of a local parameter equals some constant

case insensitive

Condition

Assigns a local parameter depending on a condition

Tests the specified parameter (Datanode) case-sensitive equals constant value (TableTarget). If equals then the specified target parameter (NewParent) is set to ifTrue-value (ConnString) otherwise ifFalse-value (Select).

• Datanode: test parameter
• NewParent: target parameter
• ConnString: ifTrue value
• Select/Values: ifFalse value
• Targettable: condition string

LogOnAsAnonymousUser

Logon

Gets a anonymous user and performs a logOn

GetAnonymousUser

Gets a anonymous user

LogOn

Logon

performs a logOn

CopyPages

Deploys all pages of a user to another user

SyncPages

Synchronizes the pages of an user with an source user: Deploys all pages of the source user and removes all pages of the target user that are not from the source user

RecalcNode

Recalculates a data node

SPX_VALIDATE_OTT

SpxEmployeeLogOn

Logon

LogOnParams_Convert_PageId