Processing multiple queue items as a single transaction

Help Studio
, ,
1

Hi,
Template using: RE-Framework

Input: From Sql query which returns multiple rows of data
image

Automation Flow/Requirement: Grab the input data from the queue and enter the data to a desktop application based on certain condition. If the SQL query returns data which have multiple “ID” row data same, for example id=2 has 2 rows, bot should enter the data to the desktop application by adding a comma(or whatever like reopening the particular screen again).

Issue: How should the flow look like? What logic is appropriate for this requirement?
The transactions are separate as we have different queue items per input row. Now if the row 2(transaction no 2) has some system/ business exception then row 3(transaction no 3) should not be processed and should be marked as failed. Somehow transaction 2 and transaction 3 should be connected. Is some kind of reference file needed to keep track of the input data processed?(Not sure)

Now, I am thinking this problem via a RE-Framework logic, if there’s an optimal way to tackle this problem let me know.

Thanks!

2

Hi @Sunny_Jha

You can add reference to the items while adding the items to queue and make sure you add same reference to items with same id. SO when items are retrieved you can first do a check by getting queue items if any item with same reference is failed or not and then proceed accordignly

reference can be something like id_date

In reference you have option to check with reference starts with as well while getting the queue items . SO if you want to make the reference unique but still use it to identify then in reference you can appended amount as well but when doing get queue items to check you can get queue items based on reference which starts with id_date alone

cheers