3 Replies Latest reply on Apr 13, 2010 3:17 AM by Hong Vo

    Linking sub processes to parent processes through SQL

    Simon Clerck Newbie

      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