Information about tasks that were assigned to a group
Hello dear AgilePoint Community,
Is there a way from AgilePoint's database to get all the process instances that have some tasks that were assigned to a certain group?
I know that the [WF_MANUAL_WORKITEMS] table has information about the tasks but I only see information about the individuals tasks that were sent to members of the group but I don't see a way to find out from which group originated those individual tasks.
Basically, the goal is to be able to produce a report for one of our application that will list all the process that currently have a task assigned to a certain group (in queue) and also those that are now assigned but originated from that group queue.
Thank you very much!
-
Jean,
In [WF_MANUAL_WORKITEMS] table the column [POOL_ID] indicates the tasks are assigned to Group users.
SELECT * FROM [AP_Workflow_DB].[dbo].[WF_MANUAL_WORKITEMS] where POOL_ID is not null and LEN(POOL_ID)>0
note: All Task's of an activity instance which are created as part of group assignment will have the same value. So, you can also group the result by POOL_ID to have tasks segregated.
Since you need the report per application, you can use something like below query to get started with data of all Tasks which due to group assignment and is part of the specific application.
SELECT * FROM [AP_Workflow_DB].[dbo].[WF_MANUAL_WORKITEMS] where POOL_ID is not null and LEN(POOL_ID)>0
and PROC_DEF_ID in (Select DEF_ID from [AP_Workflow_DB].[dbo].[WF_PROC_DEFS] where APPL_NAME = 'My Application')Hope it helps.
-
Hello Harish,
Thanks for your help. I think now I better understand how POOL_ID and Activity Instances are working but unfortunately, this won't help me to produce exactly the report that I need. Sadly, in the WF_ACTIVITY_INSTS table, we still don't have the name of the group to whom that group assignment was sent.Our application is a HUGE process containing a lot of subprocesses and during the lifetime of the process, a bunch of different tasks could even be sent dynamically to different team. So now some team wants to be able to know at this time, what are all the task that are opened and assigned to our team plus what are all the task that were originally assigned to us but that someone from our team picked up in the queue and is currently working on it.
I think I have a workaround in mind by using our own database on the side but it will required some development so I was wondering if there was an easier way straight form Agilepoint's database.Thanks for your help!
請登入寫評論。
評論
3 條評論