Author: alex.guizar(a)jboss.com Date: 2008-09-25 11:24:27 -0400 (Thu, 25 Sep 2008) New Revision: 2383 Modified: jbpm3/branches/aguizar/modules/core/src/main/resources/org/jbpm/db/hibernate.queries.hbm.xml Log: removed distinct clause from pooled task list queries Modified: jbpm3/branches/aguizar/modules/core/src/main/resources/org/jbpm/db/hibernate.queries.hbm.xml =================================================================== --- jbpm3/branches/aguizar/modules/core/src/main/resources/org/jbpm/db/hibernate.queries.hbm.xml 2008-09-25 09:12:32 UTC (rev 2382) +++ jbpm3/branches/aguizar/modules/core/src/main/resources/org/jbpm/db/hibernate.queries.hbm.xml 2008-09-25 15:24:27 UTC (rev 2383) @@ -356,9 +356,9 @@ <query name="TaskMgmtSession.findPooledTaskInstancesByActorId"> <![CDATA[ - select distinct ti - from org.jbpm.taskmgmt.exe.PooledActor pooledActor - join pooledActor.taskInstances ti + select ti + from org.jbpm.taskmgmt.exe.TaskInstance ti + join ti.pooledActors pooledActor where pooledActor.actorId = :swimlaneActorId and ti.actorId is null and ti.isSuspended != true @@ -368,9 +368,9 @@ <query name="TaskMgmtSession.findPooledTaskInstancesByActorIds"> <![CDATA[ - select distinct ti - from org.jbpm.taskmgmt.exe.PooledActor pooledActor - join pooledActor.taskInstances ti + select ti + from org.jbpm.taskmgmt.exe.TaskInstance ti + join ti.pooledActors pooledActor where pooledActor.actorId in ( :actorIds ) and ti.actorId is null and ti.isSuspended != true