Cisco Cisco Process Orchestrator 3.0 User Guide

Page of 242
 
12-3
Cisco Process Orchestrator User Guide
OL-30196-01
Chapter 12      Advanced Authoring Concepts
  Using Table Activities
Using Table Activities
You can use Table activities to modify the format for existing defined table variables. 
Note
Any boolean and numeric values that are used by the Table activities in the product are not localized. 
Numbers use [ . ] for the decimal format regardless of the regional and language options. Boolean values 
for substitutable boolean must be true or false regardless of the installed language.
For example, you can:
Table 12-2
Sample Table Activities  
Activity Type
Purpose
Add Row to Table
Append new rows to a table variable. The row is added to the end of the 
table. 
This activity will not work on tables that are outputs of other activities. 
Analyze Table 
Summarize and analyze data in a table variable or property using basic 
aggregation functions. 
Highlight Row
Highlight selected rows of a table variable. Highlighted rows can only 
be displayed in an automation summary. Therefore you will not see the 
highlighted rows in Process Orchestrator unless you are viewing the 
automation summary.
Select From Table
Query and select rows from a source table using specified criteria. The 
user can also determine the order of the rows selected as well as limit 
the number of rows displayed.
Set Table Variable
Modify the value of a defined table variable. You must specify a name 
for the activity, choose the defined variable that you want to modify, and 
enter a new value for the table variable using a different table variable 
property.
The table variables used must match in their entirety, including the 
name of columns, number of columns, and the type of columns or the 
activity will fail.
Update Row in Table
Update the selected rows of a table variable. The new rows become part 
of the variable being modified. You will not see the modified rows in the 
automation summary, but you can see the rows in the variable property 
pages in Process Orchestrator. 
This activity will not work on tables that are outputs of other activities.
Remove Row from Table
Remove one or more rows from a table variable based on specified 
criteria. 
This activity will not work on tables that are outputs of other activities.