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