Count process instance (active process) by business key

minhquankq — Fri, 28 Oct 2016 04:43:57 GMT

- I want to group process instance by business key, do ProcessInstanceQuery support to group operation?

Re: Count process instance (active process) by business key

motorina0 — Wed, 23 Nov 2016 10:23:18 GMT

Hi,
   I do not think ProcessInstanceQuery supports grouping directly, but you can use the native queries to write your own SQL statements.
   For example:
<code>List<HistoricProcessInstance> processes = historyService.createNativeHistoricProcessInstanceQuery().sql("select * from ACT_HI_PROCINST…").list();</code>

    Also, for performance reasons, it is better to use the HistoryService, than the RuntimeService.

br,
Vlad

topic Re: Count process instance (active process) by business key in Alfresco Archive

Count process instance (active process) by business key

Re: Count process instance (active process) by business key