[jboss-user] [JBoss jBPM] - Query certain processes for tasks

[twiceknightly]

Hi,

I need to be able to get all of the open tasks, assigned to users whos id's are supplied in a list list, for a number of specified processInstances.  Therefore I will pass in a list of user ids and a list of processInstances.

Does anyone know what the hibernate query for that will look like to do that?  I'm not really familiar with hibernate.  I did put the following query together, in my version of the hibernate.queries.hbm.xml file, to get all open tasks for a list of users.  I just need to be able to do it for a number of processInstances.  Can I do this in a single query? 

thanks in advance.


  |    <query name="TaskMgmtSession.findOpenTasksOfProcessInstanceByActorIds">
  |     <![CDATA[
  |       select ti
  |       from org.jbpm.taskmgmt.exe.TaskInstance as ti
  |       where ti.actorId in ( :actorIds )
  |         and ti.isSuspended != true
  |         and ti.isOpen = true
  | 		and ti.token.processInstance = :processInstance
  |     ]]>
  |   </query>
  | 

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4143906#4143906

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4143906