Content Services (ECM)
Process Services (BPM)
Application Development Framework
Digital Business Platform
Announcements & Opportunities
Alfresco Ambassador Program
Alfresco Process Services & Activiti (BPM)
to create and rate content, and to follow, bookmark, and share content with other members. Not a member?
Count process instance (active process) by business key
Question asked by
on Oct 28, 2016
on Nov 23, 2016 by motorina0
Show 0 Likes
- I want to group process instance by business key, do ProcessInstanceQuery support to group operation?
No one else has this question
Mark as assumed answered
This content has been marked as final.
Show 1 comment
(Required, will not be published)
Nov 23, 2016 10:23 AM
I do not think ProcessInstanceQuery supports grouping directly, but you can use the native queries to write your own SQL statements.
<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.
Show 0 Likes
Retrieving data ...
Deploying and Running Alfresco Content Services 6.0
Determine which sandbox is previewed
Creating your first application with ADF
Deploying Alfresco Content Services Community Edition 201806 GA
Running and using the application