topic Re: HistoricProcessInstanceQuery.processVariableEquals in Alfresco Archive

HistoricProcessInstanceQuery.processVariableEquals

stainii — Tue, 27 Jan 2015 15:23:23 GMT

Hi guys,The HistoricProcessInstanceQuery has a method .includeProcessVariables but no methods like .processVariableEquals().What's the reason this is not included?Can I use something else to query only the finished processes which contain a certain process variable?Thanks,Stijn

Re: HistoricProcessInstanceQuery.processVariableEquals

martin_grofcik — Wed, 28 Jan 2015 09:03:14 GMT

Hi Stijn,

there are several ways how to query data from the activiti:
http://www.activiti.org/userguide/#queryAPI

Regards
Martin

Re: HistoricProcessInstanceQuery.processVariableEquals

stainii — Wed, 28 Jan 2015 09:17:01 GMT

Thank you for your comment.

It's clear to me you can query with the API and native queries. However, in my case the API does not provide what I need and I'm a bit in the dark which native query to write. I did not find any documentation about what each table contains, like: does ACT_RU_VARIABLE hold both task local and proces variables? And how to differentiate them? Which relation do the have to the history tables?

Re: HistoricProcessInstanceQuery.processVariableEquals

martin_grofcik — Thu, 29 Jan 2015 07:47:38 GMT

Hi Stijn.

ACT_RU_VARIABLE has task_id_, process_instance_id_, execution_id_ these keys reference task, execution, process_instance.
History tables have the same keys. (History tables store only information from the past and runtime tables store current state of the engine)

To get deeper knowledge about activiti DB structures I would suggest to dig into the activiti sources.
Regards
Martin

Re: HistoricProcessInstanceQuery.processVariableEquals

stainii — Thu, 29 Jan 2015 10:47:11 GMT

Thank you!