Blue Prism DB structure
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-05-21 04:37 AM
Dear,
I am trying to retrieve some data from BP DB daily, the purpose is to retrieve daily data such as how many works do the robot created, completed, and failed.
I have a work queue item and every time robot finish the process, robot will update the queue item or create a queue item.
I can get what I want in BP control room but I have no idea how to retrieve those data from BP Database.
Could anyone share their experience or some advice to me?
Thanks.
I am trying to retrieve some data from BP DB daily, the purpose is to retrieve daily data such as how many works do the robot created, completed, and failed.
I have a work queue item and every time robot finish the process, robot will update the queue item or create a queue item.
I can get what I want in BP control room but I have no idea how to retrieve those data from BP Database.
Could anyone share their experience or some advice to me?
Thanks.
4 REPLIES 4
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-05-21 05:48 AM
Hello,
The table is "[BPAWorkQueueItem]". Here you have the items with the status, Join with this one "[BPAWorkQueue]" to know the name of the queue.
Bye 🙂
The table is "[BPAWorkQueueItem]". Here you have the items with the status, Join with this one "[BPAWorkQueue]" to know the name of the queue.
Bye 🙂
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
13-05-21 04:55 AM
Thanks for your answer Sarabia,
But is it possible to get the column with lock?
As I also want to get not only the status, but also those items are locked when they are processing.
But is it possible to get the column with lock?
As I also want to get not only the status, but also those items are locked when they are processing.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
13-05-21 03:32 PM
For the lock column, join BPAWorkQueueItem with BPACaseLock.
Another useful join is if you need to extract tags from work queue items, you can join BPAWorkQueueItem with BPAWorkQueueItemTag, then BPAWorkQueueItemTag with BPATag.
Another useful join is if you need to extract tags from work queue items, you can join BPAWorkQueueItem with BPAWorkQueueItemTag, then BPAWorkQueueItemTag with BPATag.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
13-05-21 03:55 PM
For discoveries you can use the same Query that Blue Prism uses for this, this is the query responsible for viewing the Queue management.
With that to be able to create good indicators
If this helps you in any way, mark it as useful.
With that to be able to create good indicators
If this helps you in any way, mark it as useful.
Sr Cons at Avanade Brazil
