topic RE: Key / Work Queue in University Forum

Key / Work Queue

SamLima — Mon, 16 May 2022 11:38:00 GMT

**************Update I forgot to upload screenshot

where did these queue Items get their key from?

it's from BP Travel Templates

I can see it used Item Key to check if an item with a specific key is in Queue or not, but I can't find where it gives this Item to that key

------------------------------
Sam Lima
------------------------------

RE: Key / Work Queue

Tejaskumar_Darji — Mon, 16 May 2022 12:57:00 GMT

It is the column name of your collection that you're using while loading data to the queue.

So that column name you need to enter in Queue settings - Key Name field.

So in your workflow, you can add a new column and populate your item key the way you want and just provide the name of that column in work queue system settings.

Here are example screenshots.

Hence the value in your Unique Key field will be taken as item key and you can see that in control room.

------------------------------
Thanks & Regards,
Tejaskumar Darji
Sr. RPA Consultant-Automation Developer
------------------------------

RE: Key / Work Queue

devneetmohanty07 — Mon, 16 May 2022 13:01:00 GMT

Hi Sam,

The Item Key that you mention in the queue configuration is automatically mapped to column name of the collection that you will sending in the 'Add To Queue' action.

For example, you can see the queue configuration that I have for a sample process:

Now, you see my my workflow just before executing the 'Add To Queue' action below:

Since in my collection that will be added to queue, I have the same column name called as 'Product Code' that is the reason how automatically in the back end Blue Prism was able to understand which column value needs to be mapped as the key name for the queue.

------------------------------
----------------------------------
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

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

RE: Key / Work Queue

SamLima — Mon, 16 May 2022 13:09:00 GMT

thank you @Tejaskumar_Darji

------------------------------
Sam Lima
------------------------------

RE: Key / Work Queue

SamLima — Mon, 16 May 2022 13:11:00 GMT

@Devneet Mohanty, thank you but I mean in BP Travel Template what did the template put as item key in System Tab, I forgot to upload the screenshot

------------------------------
Sam Lima
------------------------------

RE: Key / Work Queue

michaeloneil — Mon, 16 May 2022 13:27:00 GMT

Hi Sam

Are you wanting to know how to set the key for an item when adding it to the queue? The key is set in the settings of blueprism under work queus (see screenshot below). The name of the key can be anything you want to match the data you are adding to the queue. In the vbo Work queues > Add to queue for the data collection it would be in this data that the key is set. It doesnt need to be called KEY for example if the data you are setting in the queue was a list of items taken from a database and one of the columns is called CaseID then you could set the work queue key name to be CaseID and when added to the queue this will be the key.

------------------------------
Michael ONeil
Technical Lead developer
NTTData
Europe/London
------------------------------

RE: Key / Work Queue

SamLima — Mon, 16 May 2022 13:35:00 GMT

Hi @Michael ONeil

So template didn't use Key in System tab? just the developer puts what he wants to filter on key field in the action?

------------------------------
Sam Lima
------------------------------

RE: Key / Work Queue

michaeloneil — Mon, 16 May 2022 13:38:00 GMT

Hi Sam

Based on the screenshot you have provided it looks like the key is the Postcode Contact Number _ request date _ e.g. EY11ST07652378452_12/04/2022 this will likely be a custom key set in the column when the data was added to the queue.

------------------------------
Michael ONeil
Technical Lead developer
NTTData
Europe/London
------------------------------

RE: Key / Work Queue

michaeloneil — Mon, 16 May 2022 13:40:00 GMT

The key name can be anything it can be KEY or CaseID, Name etc so if its still called KEY then when the data was added to the queue the Data collection would have had a column name called KEY and the rows in this column would be what is set for the queue key value.

------------------------------
Michael ONeil
Technical Lead developer
NTTData
Europe/London
------------------------------

RE: Key / Work Queue

devneetmohanty07 — Mon, 16 May 2022 13:43:00 GMT

Hi Sam,

Perhaps if you once check the queue configuration I think you will get an exact idea regarding what is the column name. By looking at those screenshots, my fair guess here is that they are reading the input file and then they are creating a custom column with a formula using right and left operation which you have shown.

Once the custom column has been created then they simply add the collection to the queue. In the queue configuration side as well, they name the 'Key Name' field according to that custom column only so that the calculated value as per the formula gets added as the Key Name for each queue item.

First check what is the Key name given in the queue configuration under System tab and then in your workflow see how that column value is being set up that should confirm my guess there.

------------------------------
----------------------------------
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

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

RE: Key / Work Queue

SamLima — Mon, 16 May 2022 13:49:00 GMT

@devneetmohanty07 this is the queue used in BP Travel

------------------------------
Sam Lima
------------------------------

RE: Key / Work Queue

devneetmohanty07 — Mon, 16 May 2022 13:54:00 GMT

Now, can you show me where the ItemKey column value is being set up in your workflow. This is definitely a custom generated column and it wont be a part of your input file (you can also cross verify that)

I think I found it in one of the workflows I had for the challenge:

Here they are creating this column value via some formula and that same column name is being used in your queue configuration that is why it is getting mapped like that and you are also able to use the same formula in your 'Is Item In Queue' action while verifying if any queue item with same key name as generated by the formula already exists or not

------------------------------
----------------------------------
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

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

RE: Key / Work Queue

SamLima — Mon, 16 May 2022 13:56:00 GMT

expression has been written in key value field is not in key field within System Tab

@devneetmohanty07

------------------------------
Sam Lima
------------------------------

RE: Key / Work Queue

devneetmohanty07 — Mon, 16 May 2022 14:00:00 GMT

In System tab you just define column name nothing else no value no formula. If I let say add the Key Name as 'Test' tomorrow and if sometime in my workflow I add a custom column as 'Test' in the collection which I need to add in the queue as a part of my workflow then the same thing will appear.

Since, here they are creating this column value via some formula that is the reason why you are also able to use that formula as a filter keyword for your queue item check in the 'Is Item In Queue' action as well. Here you see the column name is:
and the same column name as been provided as your 'Key Name' in the queue configuration

------------------------------
----------------------------------
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

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