Linking sub processes to parent processes through SQL

[sclerck]

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

[kukeltje]

This is probably caused by the history not being fully implemented. Please search the jira and vote for the respective issues.

[sclerck]

Found it:

https://jira.jboss.org/jira/browse/JBPM-2772

Please advise if you require more information on this.

Thanks,

Simon

[hongvo]

Simon Clerck wrote:

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'm facing the exact problem the same problem was also raised in another discussion: https://community.jboss.org/message/400011#400011.

I want to show the entire history path for a process and other sub  processes within that process, but I have not managed to find a way of  doing this properly. I see that in the JBPM4_EXECUTION table there are  two columns SUPEREXEC_ and SUBPROCINST_ that seem to be set correctly during execution,  but these don't exist in the JBPM4_HIST_PROCINST or JBPM4_HIST_ACTINST.

Does  anyone know how to fetch the parent/child process in the history part  or if this is not yet implemented? I couldn't find any jira for this,  but will register one if there is no way of getting the parent/child  history relation this at the moment.