Configure a Complex variable activity

Add row

1. When you select a Complex variable, all the columns configured in the complex variable are listed in the table as per the names that you have provided for the columns.
2. For each column, provide either an inline value or select a process or server variable.

   • Any column that is not mapped will use the default values at runtime.

   • A numeric value should be set to 0.

   • A boolean value should be set to false.

   • A string value should be empty.

   • A date value should be set to the current date and time.

When you execute this activity, at runtime a row is added to the selected variable at the end of the array with the values specified.

Delete rows using either of the following methods:

• Index: Provide an index value to delete.

  Provide a value for the Row index, that is, the rows you want to delete.

• Custom search: Define the search criteria for deleting. You can add, delete, and modify the search criteria.

  1. Click  for Search criteria.

  2. Provide the name and value using an inline value or process or server variable.

  3. Click Add.

     When you execute this activity, at runtime the row at the specified index is deleted or any row that matches the search criteria is deleted from the array. If the row doesn't exist an error is displayed.

Update the cell values using either of the following methods:

• Index: Provide an index value to update. You can add more than one column to update.

  1. Provide a value for the Row index, that is, the row at which you want to update the value.

  2. Click  for Update columns.

  3. Provide the name and value using an inline value or process or server variable.

  4. Click Add.

     You can add multiple columns to update.

• Custom search: Define the search criteria. You can add multiple search criteria.

  1. Click  for Search criteria.

  2. Provide the name and value using an inline value or process or server variable.

  3. Click Add.

  4. Click  for Update columns.

  5. Provide the name and value using an inline value or process or server variable.

  6. Click Add. You can add multiple columns to update.

     When you execute this activity, at runtime the columns in the row at the specified index are updated with the specified values, or the row that meets the search criteria is updated. If the row does not exist an error is displayed.

Get row(s) using either of the following methods:

• Index: Provide an index value to get the rows you want. You can add multiple columns to return.

  1. Provide a value for Row index, using an inline value, or process or server variable.

  2. For Return data add the columns to be returned and map the columns to the targets using a process or server variable.

  3. On the Row count, select the Long or Short type variable.

• Custom search: Define the search criteria. You can add multiple search criteria.

  1. Click  for Search criteria.

  2. Select a name (column) and provide a value using an inline value or process or server variable.

  3. Click Add.

  4. To return the row data, on the Popup return variables list, select a dynamic complex variable.

  5. Add one or more columns and map them to return the result of the complex variable.

  6. On the Row count, select the Long or Short type variable.

     When you execute this activity, the data from the row at the specified index is returned with the correct variables, or any row that matches the search criteria is returned with the mapped complex variable. If the row does not exist, an error is displayed.