Clarity

Expand all | Collapse all

STEP START/FINISH DATE

Jump to Best Answer
  • 1.  STEP START/FINISH DATE

    Posted 07-20-2016 04:25 PM

    Hello,


    Is it posible get the start/finish date from a process "x" and step "y" in a portlet?

    I will apreciate if you give me the query.

     

    Thanks,

     

    Jonathan



  • 2.  Re: STEP START/FINISH DATE
    Best Answer

    Posted 07-20-2016 08:21 PM

    Try this:

    select rs.start_date, rs.end_date from

    BPM_RUN_STEPS rs, BPM_RUN_PROCESSES rp

    WHERE rp.id = rs.process_instance_id



  • 3.  Re: STEP START/FINISH DATE

    Posted 07-22-2016 11:38 AM

    Hi roland.parrotte,

     

    Thanks, but where should i especify the process and step name/code?

     

    Jonathan



  • 4.  Re: STEP START/FINISH DATE

    Posted 07-22-2016 08:53 PM

    Have you tried google to answer this one? For example Process Stuck in Aborting will point you to bpm_def_processes and bpm_def_process_versions (and if use bpm_def_processes_v remembering to filter by your language code will also give you the process name).  If you need the step name, then bpm_def_steps (or bpm_def_steps_v) will have the step code (or step name).

     

    But, please note, this data is lost when the process instance is deleted, so if you need it for ever, then you are better modifying/creating a process that captures this data.