Hi Mukesh, thanks for the logic and detailed explanation of this use case but I am still running into an issue with this logic. You mentioned in the comment section that we can do whatever we needed there. My use case is generating an audit log report of the new queue items from the queue. After getting the first 100 queue items, I loop through all of them, do a get transaction on a particular queue item, add specific content values to a data table, and then set the transaction status as successful. But when the BOT goes to get queue items a second time in the do while loop and gets all the new items it's skipping the remaining new items which cause items to stay in the new state in the queue. Any thoughts on this? Any help will be appriciated.
1. Check After the set Transaction status the Item status are updating properly. 2. In get Transaction - validate the Filter that what are you reading 3. Create a new queue with only 5 Items and Run the automation in debug mode to see whats Happening.
1. Create a new Integer variable called Total . 2. Assign the Default value to 0 3.. After the getQueueueItem - Take a Assign activity and Count the No.of Items (say- Items) 4. Total = Total + Items 3. The scope of the Total Variable should be to the complete flow 4. After the Loop end - simply print total - It will have the number
What happens if there are exactly 400 items in my queue? 4 iterations are done and 5th iteration starts with Skip=400 and bot tries to execute get queue item
It will read nothing and stop the loop as the queue item count condition would fail.. I would suggest create a automation with this scenario and run .. you would understand
This simply means that there are some parameters which are not getting satisfies Check the folder name , queue name , before adding the data , check the data in the locals panel Make sure the headers in the dataTable does not have any special characters… even if you have a dot in header .. remove that
@@MukeshKala when the bot will go to pickup next queue item at that time there was no item available as per condition [ skip - 400 , get again - 100 item ]
Transactions are stored in Queue - we Read the Details from the Queue and Process It - So we just Process It - NO need to Store them as they are already available in Orchestrator . .
You have unique reference in queue so when fetching the data I can have a logic which says generate the random unique reference and pass that unique reference to get the items
Super. I noticed this limitation during the day of Prod deployment. This video saved me as I was able to fix it within 30 mins :)
Great to hear!
Is there any way to merge outputs of get queue item?
No need to Merge - Its already a Collection.
thank you so much for sharing knowledge
Thank you 😊
This is just awesome!!!!!!!!!
Thank you 😊
Hi Mukesh, thanks for the logic and detailed explanation of this use case but I am still running into an issue with this logic. You mentioned in the comment section that we can do whatever we needed there. My use case is generating an audit log report of the new queue items from the queue. After getting the first 100 queue items, I loop through all of them, do a get transaction on a particular queue item, add specific content values to a data table, and then set the transaction status as successful. But when the BOT goes to get queue items a second time in the do while loop and gets all the new items it's skipping the remaining new items which cause items to stay in the new state in the queue. Any thoughts on this? Any help will be appriciated.
1. Check After the set Transaction status the Item status are updating properly.
2. In get Transaction - validate the Filter that what are you reading
3. Create a new queue with only 5 Items and Run the automation in debug mode to see whats Happening.
Explanation superb. I never heard this so
Thank you 😊
hey mukesh...Thanks for this good video.....i tried it but my bot running in the infinite loop? What can i do
Your while loop is not terminating … check the condition you have mentioned is correct or not and the variable scope are proper
You are super se bhi uper😜
Thank you 😇
Hello - How do I output the final number (total) outside of this loop? Once it breaks out, I only get the last number that was stored. Thanks.
1. Create a new Integer variable called Total .
2. Assign the Default value to 0
3.. After the getQueueueItem - Take a Assign activity and Count the No.of Items (say- Items)
4. Total = Total + Items
3. The scope of the Total Variable should be to the complete flow
4. After the Loop end - simply print total - It will have the number
@@MukeshKala That worked perfectly, thank you so much!
❤❤❤❤❤ its good Explenation 🍹🍹
Thank you
What happens if there are exactly 400 items in my queue? 4 iterations are done and 5th iteration starts with Skip=400 and bot tries to execute get queue item
It will read nothing and stop the loop as the queue item count condition would fail..
I would suggest create a automation with this scenario and run .. you would understand
Could you please explain how to debug the following error --> "Bulk Add Queue Items: bulkAddQueueItemsParameters must not be null Error code: 0"
This simply means that there are some parameters which are not getting satisfies
Check the folder name , queue name , before adding the data , check the data in the locals panel
Make sure the headers in the dataTable does not have any special characters… even if you have a dot in header .. remove that
How get vandordata. Xlsx file. Can we create or download any where else
Please drop me a note on mail I’d available in description and I can forward the excel and the code
Thanks
Welcome
what if we have 400 items, after skip 400 it will throw an error
No it won’t , it will stop once all items are processed
@@MukeshKala when the bot will go to pickup next queue item at that time there was no item available as per condition [ skip - 400 , get again - 100 item ]
To get 1000 queueitem , where should i do change ?
Nothing , as it is it would work
@@MukeshKala where can we store 1000... Get queue item can store only 100 items i believe
Excellent but where your storing queueitems
Transactions are stored in Queue - we Read the Details from the Queue and Process It - So we just Process It - NO need to Store them as they are already available in Orchestrator . .
how to get random item from queue ?
You have unique reference in queue so when fetching the data I can have a logic which says generate the random unique reference and pass that unique reference to get the items