topic Where all the Process Execution Variable gets stored? in Alfresco Archive

Where all the Process Execution Variable gets stored?

monika_b — Fri, 29 Nov 2013 12:46:43 GMT

After referring to your example I have a Java service task as below. please tell me where can I expect the "var1" with Value to be stored with this particular process instance? My project requirement needs to get this variable with value stored somewhere in activiti DB and later we can update this v

Re: Where all the Process Execution Variable gets stored?

trademak — Fri, 29 Nov 2013 13:08:47 GMT

It's stored in the ACT_RU_VARIABLE table if the process instance is still running. Otherwise you'll have to look in the history tables. Isn't it easier to use the Activiti API to access the variable value, instead of going directly to the database?

Best regards,

Re: Where all the Process Execution Variable gets stored?

monika_b — Tue, 03 Dec 2013 07:44:53 GMT

Thanks lot for help.

Yes I figured out it gets saved in ACT_HI_VARINST. And Yes I am using the activiti Query API (HistoricVariableInstance etc) to fetch the process variables.