topic RE: #BPTechTips - Empty Collection Test in Product Forum

#BPTechTips - Empty Collection Test

Jared.Rumball — Wed, 22 Dec 2021 03:06:00 GMT

Hi all,

A quick and simple way to test if a collection has any rows is to use a Loop stage without hooking up the loop end. If you continue on from the loop start then there is at least one row in the collection. Otherwise if you exit out of the loop end then there are zero rows.

For example:

Personally I often prefer this to using the collection count rows action followed by a decision stage to test the value. Not for everyone though I imagine, and be sure to annotate what you are doing as this may confuse other developers if they haven't seen this technique before!

By the way, I came across this tip in Blue Prism material ages ago but don't recall where so can't credit where I originally found out about it.

#BPTechTips

------------------------------
Jared Rumball
Q4 Associates Ltd
https://www.q4associates.biz/
------------------------------

RE: #BPTechTips - Empty Collection Test

devneetmohanty07 — Wed, 22 Dec 2021 03:18:00 GMT

Great tip out there! Definitely it will save certain number of stages while development 🙂

------------------------------
----------------------------------
Hope it helps you and if it resolves you query please mark it as the best answer so that others having the same problem can track the answer easily

Regards,
Devneet Mohanty
Intelligent Automation Consultant
Blueprism 6x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------

RE: #BPTechTips - Empty Collection Test

krishna.kodimurali9 — Wed, 22 Dec 2021 03:53:00 GMT

This seems to be a hidden trick !! Thanks for sharing Jared.

------------------------------
MuraliKrishna
Senior Consultant - Automation Developer
------------------------------

RE: #BPTechTips - Empty Collection Test

AndrzejKarolFidos — Wed, 22 Dec 2021 09:59:00 GMT

Very smart.

------------------------------
Andrzej Fidos
------------------------------

RE: #BPTechTips - Empty Collection Test

Neel1 — Wed, 22 Dec 2021 14:17:00 GMT

Thanks for sharing this . Never thought about this angle 🙂

------------------------------
Neeraj Kumar
Software Engineer
------------------------------

RE: #BPTechTips - Empty Collection Test

EmersonF — Wed, 22 Dec 2021 14:55:00 GMT

Nice, I always used count rows kk this will definitely help me a lot

------------------------------
Emerson Ferreira
Sr Business Analyst
Avanade Brasil
Recife
+5581988869544
If my answer helped you? Mark as useful!
------------------------------

RE: #BPTechTips - Empty Collection Test

Jrwork — Wed, 02 Mar 2022 16:55:00 GMT

Top! Thank you very much for sharing this information.

------------------------------
José Francisco Bezerra Nunes Júnior
------------------------------

Re: #BPTechTips - Empty Collection Test

Agustina_Terrile — Thu, 18 Jul 2024 13:39:46 GMT

Great idea! It's just what I needed! Thanks!