Blue Prism Product

 View Only
last person joined: 21 hours ago 

This community covers the core Blue Prism RPA product.

Back to discussions
Expand all | Collapse all

Filter Collection

  • 1.  Filter Collection

    Posted 08-15-2018 21:51
    I'm having some trouble filtering a collection using a value that's stored as a data item.  Let me explain what I'm trying to do: I've got some Work Queue Items, which when retrieved from the WQ contain a field called "Resource ID", and the value for this field has in turn been stored as a data item.  The value of this field should correspond with a field in a collection called "Work Order ID".  The collection could contain multiple rows matching this Resource ID/Work Order ID and I need to extract all of them into a separate collection, hence the use of 'Filter Collection'. However, I can't seem to get the Filter collection's 'Filter' input to retrieve the value of a data item.  For example, the following will work: "[Work Order ID] = 'ABC123456'" but if I try and use the following: [Work Order ID] = [Resource ID]  I get a null return. I've tried a range of combinations including "[Work Order ID]" = [Resource ID] but nothing seems to work.  When I entered [WO Entries.Work Order ID] = [Resource ID] it returned the whole collection. Can Data Items not be used with the Filter Collection action?


  • 2.  Hi Richard.Loughins Sure…
    Best Answer

    Posted 08-15-2018 22:29
    Hi Richard.Loughins Sure they can. Let's say you have a collection called ""Collection 1"" with a field called ""Work Order ID"", then you in Utility - Collection Manipulation action ""Filter Collection"" specify ""Collection In = [Collection 1] and Filter = ""[Work Order ID] = '"" & [Resource ID] & ""'"" Notice the characters after = '  "" & and & ""  '  "". That should do the trick. Good luck. BR, Mustafa


  • 3.  RE: Hi Richard.Loughins Sure…

    Posted 12-15-2021 06:49
    Hai mustafa iam not cleared with your Filter = ""[Work Order ID] = '"" & [Resource ID] & ""'"" Notice the characters after = '  "" & and & ""  '  ""
    please help me to for my filter arrangement 
    [Site ID] = My header
    [Site name] = My data item
    How to arrange this as per your logic

    ------------------------------
    Narayanamoorthy N
    ------------------------------

    Original Message


  • 4.  RE: Hi Richard.Loughins Sure…

    Posted 12-15-2021 13:16
    Hi,

    Try either of below syntax

    ""[Site ID] = '"" & [Site name] & ""'""

    "[Site ID] = '" & [Site name] & "'"

    ------------------------------
    Joshna Dammala
    ------------------------------

    Original Message


  • 5.  Works great Mustafa, thanks…

    Posted 08-16-2018 14:37
    Works great Mustafa, thanks very much for your help with this!  Much appreciated


  • 6.  RE: Works great Mustafa, thanks…

    Posted 12-15-2021 06:46
    Hai richard iam facing same issue like you
    can you please show your Filter arrangement here
    MY Filter arrangement is "[Site ID] = '[Site name]'" but its showing null
    please help me to for my filter arrangement as per mustafa idea 
    [Site ID] = My header
    [Site name] = My data item

    ------------------------------
    Narayanamoorthy N
    ------------------------------

    Original Message


  • 7.  No problem Richard :) Love…

    Posted 08-16-2018 18:11
    No problem Richard :) Love the strange syntax of BP! Have a great day...


  • 8.  RE: No problem Richard :) Love…

    Posted 07-30-2019 13:13
    Hi Mustafa, Wanted your advice on how to apply 2 filters at once in a Collection. I want to apply filter for finding stock of Apples in East region. Any suggestions would be appreciated. Thanks

    Region Fruit Stock Grade
    East Apple 10 A
    East Orange 15 B
    West Apple 20 A
    West Orange 25 B
    West Grape 30 C


    ------------------------------
    Aarti Bansal
    Automation Associate
    S&P GMI
    Indian/Chagos
    ------------------------------

    Original Message


  • 9.  RE: No problem Richard :) Love…

    Posted 07-30-2019 15:18

    I'm adding a C# code stage that should handle this.

    Inputs:
    Collection - Collection
    FilterString - Text (For this particular example, the value would be "`Region` = 'East' and `Fruit` = 'Apple'" (with quotes))

    Outputs:
    Sorted Collection - Collection

    String filter = "";
if(FilterString!="")
{
	filter = FilterString;
}
DataView dv = Collection.DefaultView;

	dv.RowFilter = filter;

Sorted_Collection = dv.ToTable();


    ------------------------------
    Ami Barrett
    Lead RPA Software Developer
    Solai & Cameron
    America/Chicago
    ------------------------------

    Original Message


  • 10.  RE: No problem Richard :) Love…

    Posted 08-14-2019 11:06
    Ami, any reason not to use filter action in collection manipulation?
    I know default VBOs are mostly bad, but it should work.

    ------------------------------
    Andrey Kudinov
    Project Manager
    MobileTelesystems PJSC
    Europe/Moscow
    ------------------------------

    Original Message


  • 11.  RE: No problem Richard :) Love…

    Posted 08-14-2019 15:41
    When I first started using BP, we were still on v4. I'm not sure if the VBO had been modified, or if the action didn't exist at that time, but I wound up having to write it from scratch.

    To my knowledge, it's good enough to use OOB. I just don't really go into the original version of that VBO anymore, haha. (That and I have a slight obsession with using C# for the sake of maintenance.)

    ------------------------------
    Ami Barrett
    Lead RPA Software Developer
    Solai & Cameron
    America/Chicago
    ------------------------------

    Original Message


  • 12.  RE: No problem Richard :) Love…

    Posted 04-26-2020 17:36
    Hi,
    please could you use filter action in collection manipulation? thanks

    ------------------------------
    Amby N
    ------------------------------

    Original Message


Welcome to the Blue Prism RPA Product Community!

Whether you’re looking to manage a complex infrastructure, maintain security and compliance, bring new products to market faster, or gain operational speed and agility in an uncertain economy, Blue Prism delivers — with the flexibility you need to create the business you want. From deployment on-premise, through a cloud service provider or as SaaS, to a skillful and adaptable digital workforce that continually expands to meet your enterprise needs, you can gain enhanced operational insight and control while your people reclaim the time they need to focus on great work.

Product PageKnowledge BaseBlue Prism Training Offering
Product Research ProgramUpdates, Releases & Announcements

FAQs

Blue Prism is intelligent automation — business-developed, no-code automation that pushes the boundaries of robotic process automation (RPA) to deliver value across any business process in a connected enterprise.

A combination of RPA with expanded cognitive and AI capabilities, Blue Prism is different than other automation technology on the market. With one Blue Prism license, you gain instant access to an already AI equipped digital workforce, along with the tools you need to build and delegate automations. Click here for more information on Blue Prism and Intelligent Automation.
To learn more about how Blue Prism RPA can help your organization and how much it will cost to get started, please Contact our Sales department.
Blue Prism RPA can be downloaded from our customer portal. If you would like to consume or download any material it is necessary to create an account on the Portal. Once you have registered, you can access the download options for Blue Prism here.
Yes! Installed on your own machine and supported by our training materials and product documentation, you can use all the features of the full enterprise product for free with our Blue Prism Trial – giving you the opportunity to learn the basics before moving to a full production implementation. Click here for more information and to download the trial.
Yes! You can access our known issue list for Blue Prism from our Support Portal.
Regardless of your industry, Blue Prism’s Digital Workforce can adhere to strict governance and compliance standards without limiting productivity. Click here for more information on how your industry can benefit from Blue Prism.