Michael Wohlfart [http://community.jboss.org/people/mwohlf] created the discussion "Re: Find Tasks by Candidate-Group Name" To view the discussion, visit: http://community.jboss.org/message/563249#563249 -------------------------------------------------------------- I don't think this is possible with the API, but you certainly can do this with a bit of hql hackery, the database schema is here: http://community.jboss.org/docs/DOC-14583 http://community.jboss.org/wiki/jbpm4DataBaseModel check the JBPM4_PARTICIPATION table for the entries with the group names and find the associated tasks -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/563249#563249] Start a new discussion in jBPM at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]

Michael Wohlfart [http://community.jboss.org/people/mwohlf] created the discussion "Re: Find Tasks by Candidate-Group Name" To view the discussion, visit: http://community.jboss.org/message/564247#564247 -------------------------------------------------------------- Hi William, I suppose this is what you want to do: public class TaskCandidatesTest extends JbpmTestCase {     public void testCandidatePutsTaskBackInGroup() {     deployJpdlXmlString(       "<process name='CandidatePutsTaskBackInGroup'>" +       "  <start>" +       "    <transition to='review' />" +       "  </start>" +       "  <task name='review' " +       "        candidate-groups='sales-dept'>" +       "    <transition to='wait' />" +       "  </task>" +       "  <state name='wait'/>" +       "</process>"     );         ProcessInstance processInstance = executionService.startProcessInstanceByKey("CandidatePutsTaskBackInGroup");     String pid = processInstance.getId();         Task task = taskService.createTaskQuery().processInstanceId(pid).uniqueResult();     assertNull(task.getAssignee());         processEngine.execute(        new Command<Void>() {          public Void execute(Environment environment) throws Exception {            DbSessionImpl dbSessionImpl = environment.get(DbSessionImpl.class);            Session session = dbSessionImpl.getSession();            assertNotNull(session);                       List<Task> list =            session.createQuery(                    " select p.task from " + ParticipationImpl.class.getName() + " p "                    + " where p.groupId = :groupId ")              .setParameter("groupId", "sales-dept")              .list();                 assertEquals(1, list.size());             assertEquals("review", list.get(0).getName());                return null;          }        }     );         taskService.takeTask(task.getId(), "johndoe");         task = taskService.createTaskQuery().processInstanceId(pid).uniqueResult();     assertEquals("johndoe", task.getAssignee());         taskService.assignTask(task.getId(), null);         task = taskService.getTask(task.getId());     assertNull(task.getAssignee());   } }     -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/564247#564247] Start a new discussion in jBPM at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]

Shannon Sumner [http://community.jboss.org/people/shannonsumner] created the discussion "Re: Find Tasks by Candidate-Group Name" To view the discussion, visit: http://community.jboss.org/message/565625#565625 -------------------------------------------------------------- Thanks Michael - this is what I came up with ... /**      * Gets the unassigned tasks by group.      *      * @param strGroupId      *             the str group id      * @return the unassigned tasks by group      */     private List<Task> getUnassignedTasksByGroup(final String strGroupId)     {         final ParamCommand<List<Task>> paramCommand = new ParamCommand<List<Task>>()         {               private static final long serialVersionUID = 1L;               @SuppressWarnings("unchecked")             public final List<Task> execute(final Environment environment)             {                 DbSessionImpl dbSessionImpl = environment                         .get(DbSessionImpl.class);                 Session session = dbSessionImpl.getSession();                   return session                         .createQuery(                                 " select participation.task from "                                         + ParticipationImpl.class                                                 .getName()                                         + " participation "                                         + " join participation.task as task "                                         + " where participation.groupId = :groupId"                                         + " and task.assignee is null ")                         .setParameter("groupId", params.get("strGroupId"))                         .list();               }         };           return processEngine.execute(paramCommand.setParam("strGroupId",                 strGroupId));       }       /**      * Gets the workgroup tasks by group.      *      * @param strGroupId      *             the str group id      * @return the workgroup tasks by group      */     private List<Task> getWorkgroupTasksByGroup(final String strGroupId)     {         final ParamCommand<List<Task>> paramCommand = new ParamCommand<List<Task>>()         {               private static final long serialVersionUID = 1L;               @SuppressWarnings("unchecked")             public final List<Task> execute(final Environment environment)             {                 DbSessionImpl dbSessionImpl = environment                         .get(DbSessionImpl.class);                 Session session = dbSessionImpl.getSession();                   return session                         .createQuery(                                 " select participation.task from "                                         + ParticipationImpl.class                                                 .getName()                                         + " participation "                                         + " join participation.task as task "                                         + " where participation.groupId = :groupId"                                         + " and task.assignee is not null ")                         .setParameter("groupId", params.get("strGroupId"))                         .list();               }         };           return processEngine.execute(paramCommand.setParam("strGroupId",                 strGroupId));       } -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/565625#565625] Start a new discussion in jBPM at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]