cancel
Showing results for 
Search instead for 
Did you mean: 

Trying to figure out a way to search a collection.

JariCarlson
Level 2

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
------------------------------
1 BEST ANSWER

Helpful Answers

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.

18082.png

18083.png



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

View answer in original post

11 REPLIES 11

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
------------------------------
-----------------------
If I answered your query. Please mark it as the Best Answer

Harish Mogulluri

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.

18082.png

18083.png



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

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

Hello, Jari.
 
I hope you are well.
 
Below is the list of actions:
18088.png


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

Leonardo Soares RPA Developer América/Brazil

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:

18091.png

Many thx

Ian



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

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

Leonardo Soares RPA Developer América/Brazil

Hello Ian,

Can you try importing it as a Process / Object

18111.png



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

Hi Ifeoma, that option is not available unfortunately

18122.png



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

 Thanks Leonardo, look forward to receiving it shortly 🙂



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