Table Parameters

Table parameters are used to define table data that is used by some LiveCompare actions. For example the Get SAP Objects action may use a Table parameter to specify a list of objects to retrieve from SAP.

To set the value of a Table parameter, open the Property Editor and click the field to the right of the parameter’s ‘Table’ action property. The Table Editor dialog is displayed in the lower portion of the Workflow Editor, showing the name of the parameter node being edited. Note that the workflow diagram may not be edited while this dialog is displayed.

Table Editor dialog.

Click ‘Insert Row’ to add an initial row a new Table parameter, and edit the table row directly by typing into the value cells. Click:

  • ‘Up’ to move the selected row up in the table.
  • ‘Down’ to move the selected row down in table.
  • ‘Insert Row’ to add a new entry underneath the selected row.
  • ‘Delete Row’ to delete the selected row.
  • ‘Clear’ to remove all the rows.
  • ‘Paste’ to paste cells copied from an Excel spreadsheet into the table. Rows are pasted underneath the current table contents. If you are using Chrome, a separate dialog is displayed into which you should paste the copied cells.

When editing the table’s contents, use the Tab key to move to the next table cell, or Shift+Tab to move to the previous table cell. The Up and Down arrow keys may be used to move between rows. Moving the cursor beyond the bottom row in the table (using either the Tab, Enter or Down Arrow key) adds a new row.

Click ‘Save’ to confirm your changes and close the Table Editor dialog.

If the ‘Force Upper Case’ check box is selected, all table entries will be converted to upper case when the dialog is closed using ‘OK’. Clear this check box to preserve the case of the table entries.

Managing Columns

To modify the table’s columns, click ‘Manage Columns…’. The Manage Columns pane is displayed:

Manage Columns dialog.

Click a NAME cell in the column descriptions table to edit its value directly, or a cell in the TYPE column to select the column’s type from a drop-down list. For columns of type ‘nvarchar’, specify a column length in the ‘Length:’ field. Click:

  • ‘Up’ to move the selected row up in the column descriptions table.
  • ‘Down’ to move the selected row down in the column descriptions table.
  • ‘Add’ to add a new column underneath the selected row. New columns are named COL, COL1, COL2, ..., and have the type nvarchar(255).
  • ‘Delete’ to delete the selected row.

When editing the columns, use the Tab key to move to the next table cell, or Shift+Tab to move to the previous table cell. The Up and Down arrow keys may be used to move between rows. Moving the cursor beyond the bottom row in the table (using either the Tab, Enter or Down Arrow key) adds a new row.

Click ‘OK’ to save your changes.

Creating Table Parameters using the Property Editor

Table parameters may be created for workflow actions using the Property Editor by selecting ‘New Table’ or ‘Edit’ from the drop-down list next to the appropriate action property. In this case, the Table parameter is populated where possible with the columns that the action requires. For example, when a ‘Patterns’ Table parameter is created for the Find Objects in SAP action using the Property Editor, the Table parameter has the columns TYPE, SapQuery, Like, RegEx and IorE.

Creating Table Parameters from Table Datasets

To create a Table parameter that has the same column definitions as a Table dataset in a workflow, select the Table dataset and choose ‘Make Table Parameter’ from its context menu. The new Table parameter will be populated with rows from the Table dataset, up to a maximum of 100 rows.

The number of rows in a Table parameter is displayed above the parameter node. To examine the details for a Table parameter after a workflow has been saved, double-click the node or select ‘View Details’ from the node’s context menu.