topic Collection Manipulation - Filter Collection in Digital Exchange

Collection Manipulation - Filter Collection

CraigFarley — Mon, 11 Feb 2019 05:00:00 GMT

Has anyone used this vbo? I can't get the filter to work - has anyone successfully done this or is there an issue with it?
#Collection Manipulation
#Planning and Sequencing Skill
#Blue Prism

RE: Collection Manipulation - Filter Collection

ewilson — Mon, 11 Feb 2019 05:00:00 GMT

Hi Craig, The Filter method works sort of like a SQL Select statement, so it will enumerate through the input collection checking for rows that match whatever select statement you've defined. As an example, let's say we have a collection with three rows in it and fields "Name" and "Value" (both of which are Text). The rows in the collection are: "Item 1" "Value 1" "Item 2" "Value 2" "Item 3" "Value 3" Now let's say I want to return the row with Name = "Item 3". I would enter the following select statement: "Name = 'Item 3'" Notice the double and single quotes. Hope this helps. Cheers, Eric
#Blue Prism
#Collection Manipulation
#Planning and Sequencing Skill

RE: Collection Manipulation - Filter Collection

CraigFarley — Tue, 12 Feb 2019 05:00:00 GMT

Thanks Eric, I'll give that a try.
#Planning and Sequencing Skill
#Collection Manipulation
#Blue Prism