Our customer wants to run some SQLs to list all actions whose status is "Failed" for one release, like the event list we can see from the studio. Which tables I should combine to get these data?
I can get the release list from RC_RELEASE table but don't know how to relate it with its failed actions.
Try use this query (I use MySQL DB)
It will list the failed actions for specific release id
select rcbm.name as Releaase_step_name,c.PROCESS_NAME as ProcessName,ose.step_title as AcitonName,ose.result_desc as ActionResultDesc ,rcs.stage_mode as Deployment_result,
rcm.module_mode as step_result from rc_stages rcs
inner join rc_releases rcr on rcr.id=rcs.release_id
inner join rc_modules rcm on rcm.stage_id=rcs.id
inner join rc_basic_modules rcbm on rcbm.id=rcm.id
inner join offline_execution_jobs oej on oej.id=rcm.job_id
inner join offline_step_events ose on ose.job_id=oej.id
inner join published_process s on s.ID=rcbm.published_process
inner join process_container c on c.ID=s.ID
where rcr.id = 2380 and ose.step_state like 'finished' and ose.result_type like '1'
Thanks for the quick reply. That works very well. My environment is Oracle, I changed ose.step_state like 'finished' to ose.step_state like 'FINISHED'.