How to Generate Report from WorkQueue

[rpa.rocks]

Hi,

I have one successful process for my application marking queue items as passed and failed.
I have created another process to generate a report using work Queue "Get Report Data", however, it does not return anything.
Get Completed Items and Get Exception items are working fine.

How do i generate report for all items in Queue?

 

[harish17]

Hi RPA rocks,
Could you Please share the screenshot for the inputs and outputs You gave for the Get Report Data?
Follow this steps:

1. Get all completed items
<loop(each item from get all completed items)>
i) Get item Data(Output collection
ii) Add row(Utility action - Manipulation)(You need to add row for out put collection from get Item Data)
</loop>
you will get data into the collection
In order to get this data into excel
1) Create instance
2) Create Workbook
3) Open Excel
4) Show(Optional)
5) Write collection
6) Close instance
7) Close workbook
If you try the above steps you will able to generate reports.

 

[rpa.rocks]

Hi RPA rocks,
Could you Please share the screenshot for the inputs and outputs You gave for the Get Report Data?
Follow this steps:

1. Get all completed items
<loop(each item from get all completed items)>
i) Get item Data(Output collection
ii) Add row(Utility action - Manipulation)(You need to add row for out put collection from get Item Data)
</loop>
you will get data into the collection
In order to get this data into excel
1) Create instance
2) Create Workbook
3) Open Excel
4) Show(Optional)
5) Write collection
6) Close instance
7) Close workbook
If you try the above steps you will able to generate reports.

Hi Harish,

Get Completed items and Get Exception items are working fine.
Issue is with GetReportData. It does not return anything. Refer below i/p o/p for Get Report Data and WorkQueue data.
View attachment 1549911709205.png
View attachment 1549911762426.png
View attachment 1549911821564.png

 

[harish17]

Hi rparocks ,
Your 3rd screenshot was not clear what is the exception present under tags column?

 

[rpa.rocks]

Hi rparocks ,
Your 3rd screenshot was not clear what is the exception present under tags column?

we need not worry about exception here. That was valid exception from the application.
All i need is, why Get Result Data does not return anything.

 

[jwhelan]

I think it has to do with your Finished End Date. If that field isn't populated, documentation says the action assumes the value is end of day for the date indicated in Finished Start Date. That doesn't seem to be how it's functioning though. Try adding 02/10/2019 to the Finished End Date to see if you get the desired results.

 

[rpa.rocks]

I think it has to do with your Finished End Date. If that field isn't populated, documentation says the action assumes the value is end of day for the date indicated in Finished Start Date. That doesn't seem to be how it's functioning though. Try adding 02/10/2019 to the Finished End Date to see if you get the desired results.

Thanks Jwhelan.
It worked like champ!!!

 

[Farrini]

Hi RPA rocks,
Could you Please share the screenshot for the inputs and outputs You gave for the Get Report Data?
Follow this steps:

1. Get all completed items
<loop(each item from get all completed items)>
i) Get item Data(Output collection
ii) Add row(Utility action - Manipulation)(You need to add row for out put collection from get Item Data)
</loop>
you will get data into the collection
In order to get this data into excel
1) Create instance
2) Create Workbook
3) Open Excel
4) Show(Optional)
5) Write collection
6) Close instance
7) Close workbook
If you try the above steps you will able to generate reports.

harish17, did you mean Add Row from "Collections"? I see no Add Row from "Utility - Collection Manipulation", unless I'm missing some VBO's.
Thanks!

 

[jonnymop5]

Hi Harish,
I get completed items from queue and they come is as Item IDs. I then try to do a loop to put all of the information into a collection. I can get each individual item to update via the Get Item Data but then each loop it just overrides the previous entry into collection. Any idea what I"m missing on this?

Thanks,
Jon
View attachment 1591641137569.png View attachment 1591641155443.png

Hi RPA rocks,
Could you Please share the screenshot for the inputs and outputs You gave for the Get Report Data?
Follow this steps:

1. Get all completed items
<loop(each item from get all completed items)>
i) Get item Data(Output collection
ii) Add row(Utility action - Manipulation)(You need to add row for out put collection from get Item Data)
</loop>
you will get data into the collection
In order to get this data into excel
1) Create instance
2) Create Workbook
3) Open Excel
4) Show(Optional)
5) Write collection
6) Close instance
7) Close workbook
If you try the above steps you will able to generate reports.