Avoiding Duplication in Queue While Creating Queue From Collection

Harshad.Patel

New Member
I am working on one project, where I am creating a collection using query output, and then add that collection to queue, and then again run query for new entries, and then want to add them to queue. In this case, blue prism is adding duplicate entry in case if query provide same data again and again.

Is there any way to avoid addition of duplication in queue while adding data from collection?
 

Sukesh Kumaru

Active Member
Hello,

Just provide the unique field in collection (For instance, "Customer ID") as key field while creating the queue.

and before this operation please make sure to remove duplicates from this collection by using relevant actions available in Blueprism.


Good Luck.
 

Harshad.Patel

New Member
Hi Sukesh,

Thanks for the details, I am already following the same option, but it's too complex process as we need to follow multiple actions to pull the queue data and then compare it with new collection and then get the dupe deleted from collection going to be added to Queue. The issue I am facing here is, it's getting slow down when queue size is huge.

Hence, I am looking for VBO kind of architecture if someone has achieved. :)
 

Kamal

New Member
Hi Sukesh,

Thanks for the details, I am already following the same option, but it's too complex process as we need to follow multiple actions to pull the queue data and then compare it with new collection and then get the dupe deleted from collection going to be added to Queue. The issue I am facing here is, it's getting slow down when queue size is huge.

Hence, I am looking for VBO kind of architecture if someone has achieved. :)
Hello Brother !

Did you get your query resolved ? Could you please provide the solution if you have found by now. I also have the same question.


<<I dont know how this forum works. But I have seen in maximum threads whenever someone asks an actual real time question there is no further reply on that. That's why this forum is not a suitable place i feel.>>
 
Hi Sukesh,

Thanks for the details, I am already following the same option, but it's too complex process as we need to follow multiple actions to pull the queue data and then compare it with new collection and then get the dupe deleted from collection going to be added to Queue. The issue I am facing here is, it's getting slow down when queue size is huge.

Hence, I am looking for VBO kind of architecture if someone has achieved. :)

Hi Harshad,

I've been through similar kind of situation I've used a turn around in which I get the pending and defferred items from the queues for past 2-3 days and remove the row in input collection if the item is present in get pending and defferred items collection you can achieve this by using filter collection and count the filtered rows using a decision you eliminate looping through large number of records. This saves time and reduces the complexity as well.

Hope this works for you.
 
Top