Configure a Complex variable activity

Use the following procedure to configure a Complex variable activity.

  1. Add an activity to the map.

    By default, the Configuration tab is open in the properties panel of the activity.

  2. Change the default Name of the activity to something meaningful.
  3. On the Type list, select Common > Complex variable.
  4. On the Complex variable list, select a dynamic complex variable.
  5. On the Action list, select one of the following.

    Add row

    1. When you select a Complex variable, all the columns configured in the complex variable are listed in the table.
    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 row

    Delete rows using either of the following methods:

    • Index: Provide an index value to delete.

      Provide a value for 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 cell values

    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 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 any row that meets the search criteria is updated. If the row doesn't exist an error is displayed.

    Get row(s)

    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.

  6. Save the process map.
  7. Configure other properties for this activity. See Activity properties.