Hi boerse,
I will try to share my solution to you. I assume you already know how to
add groups, users and membership. You try the solution
| <swimlane name="approver">
| <assignment expression="group(groupname)"/>
| </swimlane>
|
When it creates the task, try this SQL query:
| SELECT
| t.ID_ AS taskid,
| t.NAME_ AS taskname,
| t.DESCRIPTION_ AS taskdescription,
| u.NAME_ AS userid,
| t.START_ AS startdate,
| t.DUEDATE_ AS duedate,
| t.END_ AS enddate
| FROM jbpm_taskinstance t
| INNER JOIN jbpm_taskactorpool p ON t.ID_ = p.TASKINSTANCE_
| INNER JOIN jbpm_pooledactor pa ON p.POOLEDACTOR_ = pa.ID_
| INNER JOIN jbpm_id_group g ON pa.ACTORID_ = g.NAME_
| INNER JOIN jbpm_id_membership m ON m.GROUP_ = g.ID_
| INNER JOIN jbpm_id_user u ON u.ID_ = m.USER_
| WHERE t.END_ IS NULL
| .
This should give you the list of pooled actors with their pending tasks. Only
one can accomplish this task, when one has accomplished the task, this query
returns null. Like I said, some solutions I resort using SQL and this is one of
them.
Regards,
Elmo
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3925796#3925796
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3925796
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user
