[jboss-user] [jBPM] - Re: Tasks Assigned to Groups Not Found

[Alessandro Dionisi]

Alessandro Dionisi [https://community.jboss.org/people/cecchisandrone] created the discussion

"Re: Tasks Assigned to Groups Not Found"

To view the discussion, visit: https://community.jboss.org/message/756452#756452

--------------------------------------------------------------
Hi James,

thank you for the rapid answer. I've tried your solution and it works. The strange thing I found is that the query "TasksAssignedAsPotentialOwnerWithGroups" in the file Taskorm.xml in library jbpm-human-task-core-5.3.0-final.jar seems to be interpreted differently, on different Hibernate versions I think (3.6.10.Final vs. 3.2.2 GA). I noted this comparing the examples JBPM provides in the installer; if I start the human-task-server using the ant task (that references Hibernate 3.2.2.GA in the classpath) the query TasksAssignedAsPotentialOwnerWithGroups works and generates the following SQL:

SELECT task0_.ID AS col_0_0_, task0_.processinstanceid AS col_1_0_,
       names5_.text AS col_2_0_, subjects3_.text AS col_3_0_,
       descriptio4_.text AS col_4_0_, task0_.status AS col_5_0_,
       task0_.priority AS col_6_0_, task0_.skipable AS col_7_0_,
       task0_.actualowner_id AS col_8_0_, task0_.createdby_id AS col_9_0_,
       task0_.createdon AS col_10_0_, task0_.activationtime AS col_11_0_,
       task0_.expirationtime AS col_12_0_, task0_.processid AS col_13_0_,
       task0_.processsessionid AS col_14_0_
  FROM task task0_ LEFT OUTER JOIN organizationalentity user1_
       ON task0_.createdby_id = user1_.ID
       LEFT OUTER JOIN organizationalentity user2_
       ON task0_.actualowner_id = user2_.ID
       LEFT OUTER JOIN i18ntext subjects3_
       ON task0_.ID = subjects3_.task_subjects_id
       LEFT OUTER JOIN i18ntext descriptio4_
       ON task0_.ID = descriptio4_.task_descriptions_id
       LEFT OUTER JOIN i18ntext names5_ ON task0_.ID = names5_.task_names_id
       ,
       organizationalentity organizati6_
 WHERE task0_.archived = 0
   AND (   organizati6_.ID = 'sales-rep'
        OR organizati6_.ID IN
                        ('sales', 'Crusaders', 'HR', 'Knights Templer', 'PM')
       )
   AND (organizati6_.ID IN (SELECT potentialo9_.entity_id
                              FROM peopleassignments_potowners potentialo9_
                             WHERE task0_.ID = potentialo9_.task_id))
   AND (   names5_.LANGUAGE = 'en-UK'
        OR (SELECT COUNT (names10_.task_names_id)
              FROM i18ntext names10_
             WHERE task0_.ID = names10_.task_names_id) = 0
       )
   AND (   subjects3_.LANGUAGE = 'en-UK'
        OR (SELECT COUNT (subjects11_.task_subjects_id)
              FROM i18ntext subjects11_
             WHERE task0_.ID = subjects11_.task_subjects_id) = 0
       )
   AND (   descriptio4_.LANGUAGE = 'en-UK'
        OR (SELECT COUNT (descriptio12_.task_descriptions_id)
              FROM i18ntext descriptio12_
             WHERE task0_.ID = descriptio12_.task_descriptions_id) = 0
       )
   AND (task0_.status IN
                  ('Created', 'Ready', 'Reserved', 'InProgress', 'Suspended')
       )
   AND (task0_.expirationtime IS NULL);

Viceversa, if I start the human-task-server in my own application that references Hibernate 3.6.10.Final the query generated is:

/* Formatted on 2012/08/28 12:19 (Formatter Plus v4.8.8) */
SELECT task0_.ID AS col_0_0_, task0_.processinstanceid AS col_1_0_,
       names5_.text AS col_2_0_, subjects3_.text AS col_3_0_,
       descriptio4_.text AS col_4_0_, task0_.status AS col_5_0_,
       task0_.priority AS col_6_0_, task0_.skipable AS col_7_0_,
       task0_.actualowner_id AS col_8_0_, task0_.createdby_id AS col_9_0_,
       task0_.createdon AS col_10_0_, task0_.activationtime AS col_11_0_,
       task0_.expirationtime AS col_12_0_, task0_.processid AS col_13_0_,
       task0_.processsessionid AS col_14_0_
  FROM task task0_ LEFT OUTER JOIN organizationalentity user1_
       ON task0_.createdby_id = user1_.ID
       LEFT OUTER JOIN organizationalentity user2_
       ON task0_.actualowner_id = user2_.ID
       LEFT OUTER JOIN i18ntext subjects3_
       ON task0_.ID = subjects3_.task_subjects_id
       LEFT OUTER JOIN i18ntext descriptio4_
       ON task0_.ID = descriptio4_.task_descriptions_id
       LEFT OUTER JOIN i18ntext names5_ ON task0_.ID = names5_.task_names_id
       INNER JOIN organizationalentity user7_
       ON task0_.actualowner_id = user7_.ID
       INNER JOIN organizationalentity user8_ ON task0_.createdby_id = user8_.ID
       CROSS JOIN organizationalentity organizati6_
 WHERE task0_.archived = 0
   AND (   organizati6_.ID = 'cecchi'
        OR organizati6_.ID IN
                        ('sales', 'Crusaders', 'HR', 'Knights Templer', 'PM')
       )
   AND (organizati6_.ID IN (SELECT potentialo9_.entity_id
                              FROM peopleassignments_potowners potentialo9_
                             WHERE task0_.ID = potentialo9_.task_id))
   AND (   names5_.LANGUAGE = 'en-UK'
        OR (SELECT COUNT (names10_.task_names_id)
              FROM i18ntext names10_
             WHERE task0_.ID = names10_.task_names_id) = 0
       )
   AND (   subjects3_.LANGUAGE = 'en-UK'
        OR (SELECT COUNT (subjects11_.task_subjects_id)
              FROM i18ntext subjects11_
             WHERE task0_.ID = subjects11_.task_subjects_id) = 0
       )
   AND (   descriptio4_.LANGUAGE = 'en-UK'
        OR (SELECT COUNT (descriptio12_.task_descriptions_id)
              FROM i18ntext descriptio12_
             WHERE task0_.ID = descriptio12_.task_descriptions_id) = 0
       )
   AND (task0_.status IN
                  ('Created', 'Ready', 'Reserved', 'InProgress', 'Suspended')
       )
   AND (task0_.expirationtime IS NULL);

What do you think about it?
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/756452#756452]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20120828/8d22e9f8/attachment.html