topic Querying ProcessInstance on PROCESS_COMPLETED events in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/querying-processinstance-on-process-completed-events/m-p/12466#M5472 <HTML><HEAD></HEAD><BODY><P>I'm trying to handle a PROCESS_COMPLETED event by creating an ActivityEventListener bean:</P><P></P><P>&nbsp;&nbsp;&nbsp;@Override<BR />&nbsp;&nbsp;&nbsp; public void onEvent(ActivitiEvent event) {</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;final ProcessInstance processInstance = event.getEngineServices().getRuntimeService()<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .createProcessInstanceQuery().processInstanceId(event.getProcessInstanceId())<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .includeProcessVariables().singleResult();</P><P>&nbsp;&nbsp; }</P><P></P><P>first of all event.getProcessInstanceId() returns an id that does not exist in the database, second ProcessInsantceQuery seems to only return process instances that are not completed(hence processInstance == null). My goal is to get the variables of every process instance that is completed. how can I achieve this?</P></BODY></HTML> Mon, 17 Apr 2017 09:01:06 GMT ravenblackdusk 2017-04-17T09:01:06Z Querying ProcessInstance on PROCESS_COMPLETED events https://connect.hyland.com/t5/alfresco-forum/querying-processinstance-on-process-completed-events/m-p/12466#M5472 I'm trying to handle a PROCESS_COMPLETED event by creating an ActivityEventListener bean:&nbsp;&nbsp;&nbsp;@Override&nbsp;&nbsp;&nbsp; public void onEvent(ActivitiEvent event) {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;final ProcessInstance processInstance = event.getEngineServices().getRuntimeService()&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .createProcessInstanceQuery().processInstan Mon, 17 Apr 2017 09:01:06 GMT https://connect.hyland.com/t5/alfresco-forum/querying-processinstance-on-process-completed-events/m-p/12466#M5472 ravenblackdusk 2017-04-17T09:01:06Z Re: Querying ProcessInstance on PROCESS_COMPLETED events https://connect.hyland.com/t5/alfresco-forum/querying-processinstance-on-process-completed-events/m-p/12467#M5473 <HTML><HEAD></HEAD><BODY><P>I was able to get the variable I wanted like this:</P><P>&nbsp;&nbsp; String var = (String) ((ExecutionEntity) ((ActivitiEntityEventImpl) event).getEntity()).getVariable("var");</P><P>And I noticed that the id returned by event.getProcessInstanceId() will exist in the database after event handling is finished. Perhaps only the history of the process instance is saved in that table. My problem is fixed; but still it would be nice to be able to query finished process instances and unfinished alike.</P></BODY></HTML> Mon, 17 Apr 2017 12:54:47 GMT https://connect.hyland.com/t5/alfresco-forum/querying-processinstance-on-process-completed-events/m-p/12467#M5473 ravenblackdusk 2017-04-17T12:54:47Z