KollarM commented on issue #7211: URL: https://github.com/apache/incubator-devlake/issues/7211#issuecomment-2017343840
I'm sorry for the confusion, by accident I picked wrong example. The example shows situation of manual running the pipeline and forcing it to not have "test" and "prod" stage at all.  Data for normal situation when pipeline runs automatically after code is merged to main branch: select * from cicd_deployments where id like '%277449' --one record with result:SUCCESS status:DONE environment:PRODUCTION select * from cicd_deployment_commits where cicd_deployment_id = 'azuredevops:Build:1:277449' order by created_at desc --one record with result:SUCCESS status:DONE environment:PRODUCTION select * from cicd_pipelines where id like '%277449' -- one record with result:SUCCESS status:DONE type:BUILD environment:NULL select * from cicd_pipeline_commits where pipeline_id like '%277449' --one record result column is not present -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
