1. Using Oracle Cloud Infrastructure Process Automation
  2. Manage Data
  3. Filter Arrays

Filter Arrays

While defining data associations between process components, you can selectively filter elements from a source array and assign them to a target array object.

In the Data Association editor of a structured or dynamic process, an option to define a filter appears if the following conditions are met:

  • The target expression type is an array.
  • The source expression type is an array. The base type of the source is assignable to the base type of the target (for example, integer to double assignments).
  • Both the source and target expressions are valid.

To define a new filter:

  1. Click the Data Association icon.
  2. In the Actions pop-up, toggle the Filters button.
  3. In the resulting dialog, click Create.

    You can also do the following:

    • Select and use an already existing filter.
    • Search for an existing filter by entering its name in the Search field.
    • Edit a filter, by selecting it and then clicking the Edit icon.
    • Delete a filter, by selecting it and then clicking the Delete icon.
  4. Enter a name for the filter in the Name field, and click Create. A window to define the filter condition appears.
  5. Based on the type of your array, define a filter condition.
    1. For a simple array object (of the type integer, string, or double), an element named VALUE is present in the window, which represents each element of the source array. Drag and drop the VALUE element into the Condition field to define an expression.
    2. For a complex array data object, you can define a condition comprising all attributes it contains.
    You can use the inline expression builder to create and define expressions in the filter Condition field. See Work with Expressions.
  6. Click Save to save the filter condition.
  7. Note that the Data Association icon changes to show that a filter was applied to the data association.
  8. Click Apply.
In runtime, target arrays are populated according to the filter conditions you’ve defined.