Clarity

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

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

Hi roland.parrotte,

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

Jonathan

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.