Honestly, I felt that Queue Reports VBO is doing so many operations using code stages like excel formulas, excel templates, pivot tables, etc etc. making it a more complex solution just for the reporting. Also, it is a Queue Reporting right so we do not need any data inside the queue, I'm not sure why we are looking inside the data of a queue and why the nested collection is required here.
So instead of going with that VBO, I have seen people prefer "Get Report Data Action from Default WorkQueue VBO itself which will be a more simple, easy, and more efficient solution. (Considering that WQ data is gonna be huge in most cases)
Also, this is the reason why I was checking if we can replicate the same Control Room-"Export Current View as Report" option in some utility itself to get the CSV exports easily. As we already have this option in Control Room so there must be some SQL query or something running in the backend. This will also streamline the format of reports when generated manually OR generated by automation. -
Thread Reference My thought is to keep it very simple and straightforward and then later we can add more new functions to enrich the Reporting Utility in Blue prism.
These are just my thoughts on this from the design and general requirement perspective. Please share your thoughts as well so that we all can bring a great reporting feature to BP.
------------------------------
If I was of assistance, please vote for it to be the "Best Answer".
Thanks & Regards,
Tejaskumar Darji
Sr. Consultant-Technical Lead
------------------------------
Original Message:
Sent: 12-07-2022 00:01
From: Eric Wilson
Subject: Queue Reports VBO on DX
Thanks for the feedback @Dave Morris. I've got one more question for you and @Tejaskumar Darji. We're been toying with a mechanism to support inclusion of Collection data. I don't recall why exactly the original developer(s) of this VBO didn't implement support for it. What we've done is added logic to take any embedded Collection and convert it to JSON. We then write it to the output Collection as text. Would that be beneficial, or should we stick with the original design of ignoring embedded Collections?
Cheers,
------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
Original Message:
Sent: 12-06-2022 18:55
From: Dave Morris
Subject: Queue Reports VBO on DX
@Eric Wilson The action "Get Data From Items". It's been a while since I looked into this, but I'm glancing at what I did previously to address the issue, and what I did was to put a code stage at the beginning of that action that called a new function/sub in the Global Code to clear the DataFromItems DataTable whenever that action begins to run. I'm sure there may be a simpler way to do it, but below is what I added to the Global Code. The first line below was already there and I'm just including it to show where I placed the Sub, though I guess that doesn't matter. Anyway, I call ClearDataFromItems() right when Get Data From Items starts. I'm sure you may implement a fix differently, but I wanted to point how I did it.
This page/action appears to be called from several other pages/actions so I suppose this would affect all of them. In any case, the main thing I found was that it was adding duplicate rows when calling the action multiple times from in the same process within the same session because that DataTable was not being cleared or overwritten each time but instead was being appended to.
Public DataFromItems As DataTablePublic Sub ClearDataFromItems() If DataFromItems Is Nothing Then 'Do nothing Else 'Clear DataFromItems DataFromItems = Nothing End IfEnd Sub
------------------------------
Dave Morris
3Ci at Southern Company
Atlanta, GA
Original Message:
Sent: 12-06-2022 16:14
From: Eric Wilson
Subject: Queue Reports VBO on DX
Hi @Dave Morris, @Tejaskumar Darji,
Apologies for the delay on this. We've finally published the Queue Report VBO on the DX, and now we're looking over the design in order to address reported issues.
@Dave Morris - You had reported "...doesn't seem to clear out its collection when the action is called subsequent times." Which action(s) are you referring to? Would it be Create Performance Report (from multiple queues) or Create Performance Report (from items) actions? I've taken a quick look through the VBO and it seems there's a single Collection that doesn't have the Reset to Initial Value whenever this page runs option checked.
@Tejaskumar Darji - I saw your post yesterday about the issue of embedded Collections throwing an exception. We'll look into that.
Cheers,
------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
Original Message:
Sent: 05-02-2022 23:39
From: Dave Morris
Subject: Queue Reports VBO on DX
Hi Eric,
I don't know who maintains that VBO or if it's intended to be left as is, but there are a few issues with it. Off the top of my head, one of the issues is that it cannot correctly run multiple times in the same run as it will keep adding to the same collection thus creating duplicate rows. Basically it doesn't seem to clear out its collection when the action is called subsequent times.
I didn't spend much time looking into it because I like reinventing the wheel I guess. Just wanted to mention it so you could take note of it or let whoever maintains it to consider checking on its functionality at least regarding subsequent calls in the same session.
------------------------------
Dave Morris
3Ci at Southern Company
Atlanta, GA
Original Message:
Sent: 05-02-2022 18:16
From: Eric Wilson
Subject: Queue Reports VBO on DX
Hi @Tejaskumar Darji,
As @Neeraj Kumar pointed out, this asset is only available on the portal at the moment. You can find it here. We'll work on getting it moved over to the DX.
Cheers,
------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
Original Message:
Sent: 05-02-2022 12:29
From: Tejaskumar Darji
Subject: Queue Reports VBO on DX
I was looking for Queue Reports VBO on DX but could not locate it.
Though I was able to find it in one of the developer jumpstart here.
Since it is not on DX so thought to raise a query here about the same.
Is it safe to use this VBO or not.
------------------------------
Thanks & Regards,
Tejaskumar Darji
Sr. RPA Consultant-Automation Developer
------------------------------