Andy Yeung [http://community.jboss.org/people/andy.yeung] created the discussion "Re: Unable to getTasksAssigned in JBPM5" To view the discussion, visit: http://community.jboss.org/message/636518#636518 -------------------------------------------------------------- I found a group example in jbpm-examples. I found that the creator and actualowner is also null. I think that's by design since the user not yet pick up the task yet. I found that JBPM 5 is using hibernate 3.3. I will try to downgrade the hibernate version and see how's the SQL are generated. I guess the implicit join in the query t.taskData.createdBy and t.taskData.actualOwner force the hibernate engine to generate inner join statement. -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/636518#636518] Start a new discussion in jBPM Development at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]

Andy Yeung [http://community.jboss.org/people/andy.yeung] created the discussion "Re: Unable to getTasksAssigned in JBPM5" To view the discussion, visit: http://community.jboss.org/message/636524#636524 -------------------------------------------------------------- By converting the query from select      new org.jbpm.task.query.TaskSummary(      ...      t.taskData.actualOwner,      t.taskData.createdBy,      t.taskData.createdOn,      t.taskData.activationTime,      t.taskData.expirationTime) from     Task t     left join t.taskData.createdBy     left join t.taskData.actualOwner     left join t.subjects as subject     left join t.descriptions as description     left join t.names as name,     OrganizationalEntity potentialOwners where ... to select      new org.jbpm.task.query.TaskSummary(      ...     a,     c,      t.taskData.createdOn,      t.taskData.activationTime,      t.taskData.expirationTime) from     Task t     left join t.taskData.createdBy as c     left join t.taskData.actualOwner as a     left join t.subjects as subject     left join t.descriptions as description     left join t.names as name,     OrganizationalEntity potentialOwners where ... Now I am able to get the correct query result. :) -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/636524#636524] Start a new discussion in jBPM Development at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]