abeizn opened a new pull request, #4907: URL: https://github.com/apache/incubator-devlake/pull/4907
### Summary update dora refdiff and change lead time logic, refdiff add filter: ct.environment = "PRODUCTION" ct.result = "SUCCESS" pm.table = "cicd_scopes" change lead time: finished_commits_diffs left joincicd_pipeline_commits If the commit has the same data, the same commit with left join cicd_tasks will be associated with multiple cicd_task ids, resulting in more data, so change lead time keep the same logic. ``` select distinct ct.id as task_id, fcd.new_commit_sha, fcd.old_commit_sha, ct.finished_date as task_finished_date, cpc.repo_id as repo_id, ct.started_date -- ct.id as task_id, cpc.commit_sha as new_deploy_commit_sha, ct.finished_date as task_finished_date, cpc.repo_id as repo_id from finished_commits_diffs fcd left join cicd_pipeline_commits cpc on fcd.old_commit_sha = cpc.commit_sha left join cicd_tasks ct on ct.pipeline_id = cpc.pipeline_id left join project_mapping pm on pm.row_id = ct.cicd_scope_id where pm.project_name = "github1" and ct.environment = "PRODUCTION" ``` ### Does this close any open issues? NA ### Screenshots  ### Other Information Any other information that is important to this PR. -- 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]
