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>

[twiceknightly]

no one willing to help?

[salaboy21]

first of all figure out what query are you trying to generate in the DB...
then.. translate it to HQL.. so the question is... can you do it in one query in your DB?

If you use in ( :actorIds ) why you don't use in ( :processInstances )??