topic Filter a Collection in Product Forum

Filter a Collection

DiogoDavid — Wed, 29 Mar 2017 15:53:00 GMT

Hi everyone, I am having trouble using the "filter collection" action in the Utility Collection Manipulation. I have a collection named "Data" and 3 columns ("A", "B", "C"). Each of these columns have values "1", "2", and "3". I want to filter the collection "Data", column "B", to have only values "2". Hence, what I do is an action, using the utility collection manipulation -> filter collection. The inputs of that action are: 1) Collection In: I choose the collection "Data" 2) Filter: Here is where I am having trouble. I tried [Data.B]="2" and even though BluePrism does not recognize any error, the output remains empty. Can someone please help me? Thank you so much in advance. Kind regards

Use expression ""B='2'"" to get

KirankumarMahan — Wed, 29 Mar 2017 16:57:00 GMT

Use expression ""B='2'"" to get the filter output refer the thread https://portal.blueprism.com/managing-collection-data-items

Thank you for your feeddback.

DiogoDavid — Wed, 29 Mar 2017 18:25:00 GMT

Thank you for your feeddback. I tried ""B='2'"", and it worked: But when I try the same with the field ""B C"", it doesn´t: ""Internal: Could not execute code stage because exception thrown by code stage: syntax error: missing operand after 'C' operator. Thank you so much

Thank you for your feeddback.

DiogoDavid — Wed, 29 Mar 2017 18:26:00 GMT

Hi David,

KirankumarMahan — Thu, 30 Mar 2017 11:54:00 GMT

Hi David, Could you please explain this statement ""I try the same with the field ""B C"","" little clear so that I can help you to resolve your issue. And also please do refer the thread which I mentioned in my last comment. Thanks, Kiran

Hi Kirankumar!

DiogoDavid — Thu, 30 Mar 2017 14:13:00 GMT

Hi Kirankumar! Your solution worked fine. Thank you. However, when the field has two words (eg: ""Product Code""), when I try to filter (""Product Code='2'""), the following error occurs: ""Internal: Could not execute code stage because exception thrown by code stage: syntax error: missing operand after 'code' operator. Thanks in advance

Hi David,

KirankumarMahan — Thu, 30 Mar 2017 14:53:00 GMT

Hi David, Good observation!! I have also tried I am getting the same error. But I have tried with removing the space between product and code it is working. lets raise this issue as fresh issue to our BP forum. Thanks kiran

OK

DiogoDavid — Thu, 30 Mar 2017 15:21:00 GMT

OK Thank you so much for your help

OK

DiogoDavid — Thu, 30 Mar 2017 15:21:00 GMT

OK Thank you so much for your help

Your most welcome david

KirankumarMahan — Thu, 30 Mar 2017 15:23:00 GMT

Your most welcome david

I have also come across this

Anonymous — Tue, 16 May 2017 17:03:00 GMT

I have also come across this problem, as a workaround I am having to append the field name to remove the space. I don't think this is a long term solution to the problem.

[Security Type] = '""&Trim(

PrateekMehan — Thu, 18 May 2017 16:17:00 GMT

[Security Type] = '""&Trim([Summary of Securities List.Security Type])&""' Works fine for me though.

Hi guys, this helped a lot,

lukas_mesko — Mon, 26 Jun 2017 13:01:00 GMT

Hi guys, this helped a lot, but what if I'd like to filter 2 values from 1 field? Let's say I have a field called DESCRIPTION in a collection called Orders. From the DESCRIPTION field, I'd like to filter only Microsoft Project and Microsoft Visio. Thanks for your further help :) Lukas