Trying to figure out a way to search a collection.

[JariCarlson]

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
------------------------------

[harish.mogulluri]

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
------------------------------

[michaeloneil · Accepted solution]

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
------------------------------

[JariCarlson]

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
------------------------------

[LeonardoSQueiroz]

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
------------------------------

[Ian_At_RoyalSurrey]

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
------------------------------

[LeonardoSQueiroz]

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
------------------------------

[ifeoma]

Hello Ian,

Can you try importing it as a Process / Object

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

[Ian_At_RoyalSurrey]

Hi Ifeoma, that option is not available unfortunately

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

[Ian_At_RoyalSurrey]

 Thanks Leonardo, look forward to receiving it shortly 🙂

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