topic Trying to figure out a way to search a collection. in Product Forum

Trying to figure out a way to search a collection.

JariCarlson — Thu, 21 Dec 2023 20:56:00 GMT

So I have this collection that is [test] I am trying to determine whether [test.county] contains one of 80 possible test strings. At the moment I have a decision stage with

[test.county] = "test" OR

[test.county = "test2" OR

for all 80 of the possible text strings. I was wondering if there would be any way to more efficiently do this rather than the 80 separate OR statements.

If anyone has any feedback or ideas for this please let me know, thanks in advance.

------------------------------
Jari Carlson
------------------------------

RE: Trying to figure out a way to search a collection.

harish.mogulluri — Thu, 21 Dec 2023 23:11:00 GMT

Hi Jari Carlson,

You can use environment variable and pass as comma seperated values and extract this value as csv Collection.

Once all the values are in collection you can use this extraction collection as nested collectio to verify different condition.

This way you can modify to add new string or remove the existing with out changing the code.

You can also use code stage to perform this,

------------------------------
-----------------------
If I answered your query. Please mark it as the "Best Answer"

Harish Mogulluri
Lead developer
America/New_York TX
------------------------------

RE: Trying to figure out a way to search a collection.

michaeloneil — Fri, 22 Dec 2023 08:51:00 GMT

Hi @Jari Carlson

I would use the Utility - Collection Manipulation Extended and the action Collection contains value. This will let you set the collection you want to search, the column you want to search in and the term you need to search for. If the 80 values you need to search are static then add them to a collection and loop the collection to search for each term. Screenshots below.

------------------------------
Michael ONeil
Technical Lead developer
NTTData
Europe/London
------------------------------

RE: Trying to figure out a way to search a collection.

JariCarlson — Wed, 27 Dec 2023 19:34:00 GMT

Do you know where to find the utility Collection Manipulation Extended? I have looked around and done some googling but I can't find anywhere that mentions that as something that is available through official means.

------------------------------
Jari Carlson
------------------------------

RE: Trying to figure out a way to search a collection.

LeonardoSQueiroz — Wed, 27 Dec 2023 21:18:00 GMT

Hello, Jari.

I hope you are well.

Check the attached file: https://community.blueprism.com/viewdocument/re-remove-duplicates-from-collecti?CommunityKey=3743dbaa-6766-4a4d-b7ed-9a98b6b1dd01&tab=librarydocuments

Below is the list of actions:

Regards
------------------------------
Leonardo Soares
RPA Developer Tech Leader
Bridge Consulting
América/Brazil
------------------------------

RE: Trying to figure out a way to search a collection.

Ian_At_RoyalSurrey — Fri, 05 Jan 2024 10:37:00 GMT

Hi Leonardo

This may be a stupid question, but how do I import an xml file in to BPC? I only have these options to import a release:

Many thx

Ian

------------------------------
Ian Meldrum
Senior RPA Developer
Royal Surrey NHS FT
UK
------------------------------

RE: Trying to figure out a way to search a collection.

LeonardoSQueiroz — Sat, 06 Jan 2024 02:48:00 GMT

Hello,

I did the conversion, but I can't upload it as an attachment, I'll try to send it to you via private message.

Regards,

------------------------------
Leonardo Soares
RPA Developer Tech Leader
Bridge Consulting
América/Brazil
------------------------------

RE: Trying to figure out a way to search a collection.

ifeoma — Mon, 08 Jan 2024 10:27:00 GMT

Hello Ian,

Can you try importing it as a Process / Object

------------------------------
Ifeoma Igweze
------------------------------

RE: Trying to figure out a way to search a collection.

Ian_At_RoyalSurrey — Wed, 10 Jan 2024 15:02:00 GMT

Hi Ifeoma, that option is not available unfortunately

------------------------------
Ian Meldrum
Senior RPA Developer
Royal Surrey NHS FT
UK
------------------------------

RE: Trying to figure out a way to search a collection.

Ian_At_RoyalSurrey — Wed, 10 Jan 2024 15:04:00 GMT

Thanks Leonardo, look forward to receiving it shortly 🙂

------------------------------
Ian Meldrum
Senior RPA Developer
Royal Surrey NHS FT
UK
------------------------------

RE: Trying to figure out a way to search a collection.

MichealCharron — Wed, 10 Jan 2024 15:38:00 GMT

@Ian_At_RoyalSurrey

I believe @ifeoma was trying to point out that you would get that option if you import from the "File" menu. If you are importing from the "Releases" tab, you won't be able to import single process or object files.

------------------------------
Micheal Charron
Senior Manager
RBC
America/Toronto
------------------------------

RE: Trying to figure out a way to search a collection.

Ian_At_RoyalSurrey — Wed, 10 Jan 2024 16:29:00 GMT

Ah, that makes perfect sense and does in fact work!! Many thanks Michael

------------------------------
Ian Meldrum
Senior RPA Developer
Royal Surrey NHS FT
UK
------------------------------