[jboss-user] [jBPM] New message: "Linking sub processes to parent processes through SQL"

[Simon Clerck]

User development,

A new message was posted in the thread "Linking sub processes to parent processes through SQL":

http://community.jboss.org/message/528178#528178

Author  : Simon Clerck
Profile : http://community.jboss.org/people/sclerck

Message:
--------------------------------------------------------------
Hi,
Apologies if this has been discussed before.
Through SQL, we are trying to resolve the historical path of a particular process instance.
The problem is that the process definition includes the use of sub processes.
So, ideally, we would like to retrieve something like this:
- Start
- Sub process - action 1
- Main process - action 2
- End
 
But in the tables JBPM4_HIST_ACTINST and JBPM4_HIST_PROCINST, I can't find a way to link the sub process to its parent.
 
I thought the column KEY_ in JBPM4_HIST_PROCINST might be useful, but for subprocesses these are set to NULL.
 
Can someone please let me know if this is possible?
 
Thanks,
Simon

--------------------------------------------------------------

To reply to this message visit the message page: http://community.jboss.org/message/528178#528178