Collection Manipulation.

[JamieMcPake]

Hi All,

Wondering if anyone can help here!=

I have a collection which I need to manipulate in order to click on an item from a data table. 

My table when read, populates with the following:

And then proceeds to the filter collection stage:

Where it uses the following filter:

But when this stage is ran, the output collection does not populate.

This has been working fine the last 2 weeks and has only stopped working today.

The data item [UBRN Number] is currently formatted as a text data item, so the data types all match up.

This is the most efficient way to filter this collection as it deals with 100's of rows of data.

Any advice is very much appreciated! 

Thanks,

[devneetmohanty07 · Accepted solution]

Hi Jamie,

If your query was working for last two weeks I dont ideally think somewhat might be wrong with your code but perhaps one thing, I would definitely check would be the data in this case. Since you are using an 'Equals' match here in your Filter query, have you checked the possibility of having some whitespaces character included in that UBRN number for some reason?

What I would ideally do here is edit my query in either of the following ways if possible:

"TRIM([UBRN]) = '" & Trim([UBRN Number]) & "'" 

OR

"[UBRN] LIKE '%" & [UBRN Number] & "%'" 


------------------------------
----------------------------------
Hope it helps you out and if my solution resolves your query, then please mark it as the 'Best Answer' so that the others members in the community having similar problem statement can track the answer easily in future

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
WonderBotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

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