[jboss-user] [jBPM] - Re: Active tasks for process instance

[Esteban Aliverti]

Esteban Aliverti [https://community.jboss.org/people/eaa] created the discussion

"Re: Active tasks for process instance"

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

--------------------------------------------------------------
The best way to get this information is to use jbpm-bam module (basically it logs all the activities of your processes into a db) and to query NodeInstanceLog table. 
This is a query you can use:

            SELECT
                n
            FROM
                NodeInstanceLog n
            WHERE
                n.processInstanceId = :processInstanceId and
                n.nodeName != ''
            GROUP BY n.nodeName
            HAVING MOD(COUNT(n), 2) = 1
--------------------------------------------------------------

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

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/20120824/7b8cac8d/attachment.html