topic Re: HistoricVariableUpdate.getTaskId() always returns null in Alfresco Archive

HistoricVariableUpdate.getTaskId() always returns null

naag — Wed, 30 May 2012 03:02:16 GMT

Dear all!I'm working on a Activiti 5.9 based platform (JBoss AS 7, Java EE 6, JSF 2, CDI, …) and would like to archive a process instance when it ends. This archive should include all process variables with their history information and also the tasks that were executed (history=full is set in activ

Re: HistoricVariableUpdate.getTaskId() always returns null

trademak — Fri, 01 Jun 2012 09:11:41 GMT

Hi,

I don't understand your question. Why do you want a taskId in a HistoricVariableUpdate instance?
Why do you need this information? If you want an overview of user tasks then you should use the createHistoricTaskInstanceQuery method.

Best regards,

Re: HistoricVariableUpdate.getTaskId() always returns null

naag — Tue, 12 Jun 2012 05:09:07 GMT

Hi Tijs,

thanks for your answer and sorry for my late reply (I was on vacation ).

For archiving and auditing purposes, I need to know the task that triggered the variable update. I need the taskId to see during which task a variable update actually happened. In my example above I have two user tasks "Enter information" and "Update information". Imagine a situation during audit where the auditor needs to know who entered a particular piece of information in a process variable. If we could see the task during which a variable update took place, then we could also retrieve the information about people who were assigned to those tasks.

Is it clear?

Regards,
Peter

Re: HistoricVariableUpdate.getTaskId() always returns null

trademak — Tue, 12 Jun 2012 14:09:34 GMT

Hi,

Yeah that certainly makes sense. I don't think we store that info currently.
What you could do is check the update time with the start and end time of the tasks.
But this is certainly a valid improvement request. Could you raise a JIRA?

Best regards,

Re: HistoricVariableUpdate.getTaskId() always returns null

naag — Tue, 12 Jun 2012 18:40:16 GMT

Hi Tijs,

alright, I will raise the JIRA and also investigate if start/end time provide a viable solution.

Thanks for your input!

Regards,
Peter

Re: HistoricVariableUpdate.getTaskId() always returns null

naag — Wed, 13 Jun 2012 07:02:25 GMT

ACT-1248 has been created. Hopefully something can be worked out

Re: HistoricVariableUpdate.getTaskId() always returns null

frederikherema1 — Wed, 13 Jun 2012 09:03:50 GMT

For the record: the TASK_ID_ field is only used when the HistoricDetail is task-local variable update. So for process-variables, this does NOT indicate which task was active at the time the process-variable was set. This field is the single indicator for task-local variables and cannot be reused for the proposed functionality.

However, the ACT_INST_ID_ can be inspected to see what activity was active at that time. Based on the ACT_ID_ you can at least know the ID of the task in your BPMN. Using this, you can query for the actual HistoricTaskInstance (or multiple, if task was repeated) associated to activity.

Re: HistoricVariableUpdate.getTaskId() always returns null

naag — Fri, 15 Jun 2012 07:58:30 GMT

The issue has been solved by following Frederik's advice. Now I have a custom SQL query via JDBC to the Activiti database, which joins ACT_HI_DETAIL with ACT_HI_ACTINST. From there I can read everything I need so far. Thanks 🙂