Filter Collection

This activity allows users to filter values from a collection based on specified conditions, either retaining or removing the matching items alone.

Limitation

This activity supports collections of primitive data types—such as “Int, float, double and string” since filtering conditions can only be applied to these types.

Properties

Input

Collection: *Specifies the collection variable that contains the data to be filtered.

Filter Action: *Select the desired filter action from the dropdown:

Keep matching items: Retains only the items that meet the specified condition.
Remove matching items: Removes the items that meet the specified conditions from the collection.

Misc

Argument Type: *Select the type of elements contained in the collection from the drop-down.
For example, if the collection is a list of strings, choose “String” as the argument type.

Display Name: Displays the name of the activity. The activity name can be customized, which aids in troubleshooting.

SkipOnError: Specify the “Boolean” value as “True” or “False.”

True: Continue executing the workflow regardless of any errors thrown.
False: Halt the workflow if it encounters any errors.
None: If the option is left blank, the activity will, by default, behave as if “False” were chosen.

Version: It indicates the version of the feature being used.

Output

CollectionOutput: *Returns a list of objects containing the filtered data from the collection.

Result: This parameter allows you to view the execution status of the activity and returns a value in “Boolean.”

True: Indicates that the activity has been executed successfully without any errors.
False: Indicates that the activity has been unsuccessful due to an unexpected error being thrown.

* Represents mandatory fields to execute the workflow.

Filter Window

This wizard allows you to define specific conditions to filter and retrieve data from the provided collection.

1. AND: Returns TRUE only if allthe conditions separated by AND are true.

2. OR: Returns TRUE only if anyof the conditions separated by OR are true.

3. Name: Displays a datatype of the collection variable.

4. Operator: Specifies the comparison operator to apply on the field, such as:
a. Equals
b. Contains
c. In

5. Value: Provide the value against which the records should be filtered.

6. Add: Click on the Add button to add multiple conditions to filter. 

Click here to download and view the sample workflow using filter collection activity.