topic Re: Process instance query problem in Alfresco Archive

Process instance query problem

michael_nepyjwo — Wed, 12 Mar 2014 13:55:57 GMT

Hello,I think I'm having an issue with the runtime service and a process instance query:the query code is :…return runtimeService.createProcessInstanceQuery().processDefinitionId(processDefinition.getId()) .orderByProcessInstanceId().asc().list();}…-processDefinition.getId() is define

Re: Process instance query problem

martin_grofcik — Thu, 13 Mar 2014 07:35:10 GMT

Hi Michaël,

Try to debug your code and
on the line


return runtimeService.createProcessInstanceQuery().processDefinitionId(processDefinition.getId())
.orderByProcessInstanceId().asc().list();

try to execute runtimeService.createProcessInstanceQuery().list() - you will see all process instances in the engine.
Check whether key is not misused as Id.

Regards
Martin

Re: Process instance query problem

michael_nepyjwo — Thu, 13 Mar 2014 14:19:54 GMT

Hello Martin,

I've just tried what you suggested but the runtime service returns an empty list while some process instances are defined in the ACT_HI_PROCINST table…

Some other idea ?

Re: Process instance query problem

jbarrez — Mon, 17 Mar 2014 08:57:23 GMT

- The runtime service will NOT return process instances from ACT_HI_PROCINST, but from ACT_RU_EXECUTION.

- Does runtimeService.createProcessInstanceQuery().list() give you anything?

Re: Process instance query problem

michael_nepyjwo — Mon, 17 Mar 2014 10:34:32 GMT

Hi Joram,

runtimeService.createProcessInstanceQuery().list() returns an empty list and ACT_RU_EXECUTION is empty.

Re: Process instance query problem

michael_nepyjwo — Mon, 17 Mar 2014 10:55:10 GMT

Joram,

I found what was wrong: the runtime service only returns active process instances and mine were finished.
So there is no more problem.

Have I something to do to close this post ?

Thanks.

Re: Process instance query problem

jbarrez — Wed, 19 Mar 2014 14:24:11 GMT

Ok, good to hear. No need to close post, replying it's working is enough 🙂