Hi Jacky, I need a last additional information in the query but I cannot connect it to the data I already retrieve.
from the table "rc_release_candidate" i need the columns "Build" , "Name" , "Description" for all the deployes that are not yet ddone on the 'higher' environment.
can you tell me how I can retrieve it with the sql you already provided (and this is already a great help)
use nolio_db55;select ra.* from
(
select distinct rcr.release_candidate As Deployment_plan_id,(e.name) as Environment_name,(rcr.name) as Deployment_name,rcr.release_result as Status ,from_unixtime(rcm.startTime/1000) As Deployment_start_time, rcr.name as Deployment_plan_name,app.APP_NAME
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 environments e on e.id=rcs.environment
inner join applications app on app.id=rcr.application
where e.name ='Dev'
)ra
where Deployment_plan_id NOT IN
(
select distinct rcr_2.release_candidate As Deployment_plan_id
from rc_stages rcs_2
inner join rc_releases rcr_2 on rcr_2.id=rcs_2.release_id
inner join rc_modules rcm_2 on rcm_2.stage_id=rcs_2.id
inner join environments e_2 on e_2.id=rcs_2.environment
inner join applications app_2 on app_2.id=rcr_2.application
where e_2.name = 'Production'
)
group by Deployment_plan_id
order by Deployment_plan_id desc;