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.
select rs.start_date, rs.end_date from
BPM_RUN_STEPS rs, BPM_RUN_PROCESSES rp
WHERE rp.id = rs.process_instance_id
Thanks, but where should i especify the process and step name/code?
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.
Retrieving data ...