How to know the task's previous assignee

[hari_kiran]

Hi,

We are using Camunda 7.14.
We have a scenario where the task can be assigned between various users. I would like to know how I can find out the previous assignee (dates also if possible) of the same task.

Thank you,
Srihari.

[rohwerj]

You can use the HistoryService to create a historic task instance query with the task id.
That way you get all historic states of the task and will also find the entries with different assignees.

https://docs.camunda.org/javadoc/camunda-bpm-platform/7.14/org/camunda/bpm/engine/HistoryService.html#createHistoricTaskInstanceQuery--

[hari_kiran]

Hi,

If I have to look for the same in the database, which table should I be referring to?

Thanks,
Srihari.

[rohwerj]

Hi @hari_kiran

The corresponding table in the database is ACT_HI_TASKINST.

[hari_kiran]

Hi @rohwerj , but it only has the current assignee, the previous assignee is not available here.

[rohwerj]

Hi @hari_kiran.
Sorry, that information is really not stored in ACT_HI_TASKINST, but in ACT_HI_IDENTITYLINK and can be accessed via the createHistoricIdentityLinkLogQuery method in the HistoryService.
In ACT_HI_IDENTITYLINK you will be looking for entries with type “assignee” (column TYPE_).
The operation (OPERATION_TYPE_) is either “add” or “delete”, so if you do a reassignment, there is one entry with delete operation type for the “old” assignee and one with add for the “new”.