This action is used to filter specific rows in a collection based on a criterion. The resultant row(s) can be stored back in the same collection or in a new one
The Filter Collection action is found in the Utility – Collection Manipulation object. You will first need to import that business object – read “Objects created by Blue Prism” for more information.
As the name suggests, this action is used to filter specific rows in a collection based on a criterion. The resultant row(s) can be stored back in the same collection or in a new one.
There are 2 inputs for this action:
The only output is the name of the collection that will store the results.
If you want to refer to a data item in your filter text you will need to use concatenation to get the desired result.
Assuming [Cost Price Limit] is a number Data Item and [Cost Price] is a column in the collection.
If you create the filter as “[Cost Price] > [Cost Price Limit]”, Blue Prism will assume that [Cost Price Limit] is the name of a column and you will get an error.
You will need to create your filter like this - “[Cost Price] > “ & [Cost Price Limit].
If you want to use a text Data Item you need to make sure you include the single quotes that would normally surround the text value.
Assuming [Dept Choice] is a text Data Item and [Dept] is a column in the collection.
The filter will need to be created as “[Dept] = ‘” & [Dept Choice] & “'”