Solutions to reporting the assigned user to tasks

Q&A
1

Using Bonita Community 7.10

We output reports on a daily basis to audit. 

Each step in our process has a 'status' which represents which task has been most recently completed (and so we know which task is due next). 

However, it would be very useful to report the user who the task is assigned to, since other users in the actor group are not able to see the task when it is taken.

In which table can I find the task assignment details? And how can I link it to the bdm data? (Is this possible?)

2

Hi, Are you using APIs (Rest or Java) ? to fetch the information for your reports? Are you using a process to generate the report? Are you querying the database directly (that is not recommended as the schema change from version to version of Bonita)?

If you are using REST, the documentation of USER_TASKS available here states that the information you are looking for is in the "assigned_id": "the user id (long) that this task is assigned to, or 0 if it is unassigned". If you want to fetch the username instead of the userId, you can use the d=userId query parameter when listing tasks; it will replace the "assigned_id" value by the JSON representing the user.

If you are using JAVA: the JAVADOC says that searchAssignedAndPendingHumanTasks(...) returns a HumanTaskInstance with the assigned user available through the getAssigneeId() function.

If you are using the database, the SQL script that creates the tables indicates that there is a column named "assigneeId" in the "flownode_instance" table. (Again, I would not recommend to access directly the database, as the schema is changing between versions of the product and then your integration might break) 

 

Let me know if it helped,

Captain Bonita