Clarity PPM

Expand all | Collapse all

What it in SRC_STEP_ACTION_RESULT_ID column of BPM_RUN_PROCESSES

  • 1.  What it in SRC_STEP_ACTION_RESULT_ID column of BPM_RUN_PROCESSES

    Posted 09-19-2018 12:11 PM

    Hi there,

    What values are stored in SRC_STEP_ACTION_RESULT_ID column in bpm_run_processes table?

    In front end, I see a process has 10 instances in running state but in database it has over 150 instances showing with BPM_PIS_RUNNING state.

     

    The only difference I could see was that the instances which appear in Clarity front end have '-1' in SRC_STEP_ACTION_RESULT_ID. Other rows in DB have values like 37871791 in SRC_STEP_ACTION_RESULT_ID.

     

    Regards,

    Devendra



  • 2.  Re: What it in SRC_STEP_ACTION_RESULT_ID column of BPM_RUN_PROCESSES

    Posted 10-01-2018 01:40 AM

    Dear Devendra,

    the field indicates that it is a subprocess of another process.

    SELECT brs.process_instance_id
         , brp.id subprocess_instance_id
    FROM bpm_run_processes brp
         INNER JOIN bpm_run_step_action_results brsar ON brp.src_step_action_result_id = brsar.id
         INNER JOIN bpm_run_steps brs ON brsar.step_instance_id = brs.id

    Best Regards,

    Alexander