topic RE: Work Queues in Product Forum

Work Queues

GAVIN.RUDLING — Wed, 13 Apr 2022 16:39:00 GMT

Good Day Team,
I would like to know if there is a way to remove an item from the queue when a duplicate is detected.
So I want to remove the item that is already in the queue when the Key is identified to already be in the queue.
Any ideas?

Kind Regards
Gavin

------------------------------
Gavin Rudling
Digital Consultant & Developer
Cog3nt
Africa/Johannesburg
0813906789
------------------------------

RE: Work Queues

PabloSarabia — Wed, 13 Apr 2022 17:07:00 GMT

Hi @GAVIN.RUDLING

For removing items from the Queue is easy, use the Action "Delete Item" from the "Work Queues" Object.

To check if exists any duplicate item, you can ask first if exists the key that you want to insert before insert it. Use the Action "Is Item in the Queue" from the same VBO.

This action gives you the posibility to filter one Work Queue with different parameters, and returns a flag and a collection with all the item ids that meet the criteria.

You can make something like this:

Hope this helps you!!

See you in the community, bye 🙂

------------------------------
Pablo Sarabia
Architect
Altamira Assets Management
Madrid
------------------------------

RE: Work Queues

John__Carter — Wed, 13 Apr 2022 17:10:00 GMT

Yep it's do-able Gavin, you need the ID of the item you want rid of and then use the Delete Item action. If the duplicate is pending, you'll need to use Get Next Item to lock it, mark it complete (or exception), then delete it. To be thorough, you'd probably want to do this:

Get Exception Items using Key Filter, loop through resulting item IDs and delete each one
Get Completed Items using Key Filter, loop through resulting item IDs and delete each one
Get Next Item with Key Filter, Mark Complete, Delete, repeat until there are no more items with that key

If the duplicate is locked by another DW, then you won't be able to delete it until it's released.

------------------------------
John Carter
Professional Services
Blue Prism
------------------------------

RE: Work Queues

GAVIN.RUDLING — Wed, 13 Apr 2022 17:15:00 GMT

Hi John, Thanks for the advice. Much appreciated.

Regards

Gavin