Finding all running process instances for a process definiti

[nbhatia]

How do I find all running process instances for a process definition? I tried GraphSession.findProcessInstances(long processDefinitionId), but this method returns all process instances including those that have ended (potentially a very expensive query).

I found the following named query in hibernate.queries.hbm.xml. This is exactly what I need, but I cannot find any method in the source that uses this query.

 <query name="GraphSession.findAllRunningProcessInstancesWithProcessName">
 <![CDATA[
 select pi
 from org.jbpm.graph.exe.ProcessInstance as pi
 where pi.processDefinition.name = :processDefinitionName
 and pi.end = null
 order by pi.start desc
 ]]>
 </query>

Can someone tell me how I can leverage this query? (I am using jBPM 3.2.3).

Thanks.
Naresh

[kukeltje]

might be that it is a left-over or.... it might be used in the console project (so not the core) e.g. for BAM/BI

Running this query is simple though... it's just hibernate.... get a hibernate session from the jbpm context and do any hibernate on it (or even plain sql)

[kukeltje]

any hibernate should ofcourse be any hql

[nbhatia]

Ah ok! That was the missing link I was looking for. Still getting used to the API. Thanks so much.