d4x1 opened a new issue, #6721: URL: https://github.com/apache/incubator-devlake/issues/6721
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/incubator-devlake/issues?q=is%3Aissue) and found no similar issues. ### What happened In PR #6698, we update the ways that can generate `cicd_deployments` table, and it leads to `cicd_deployments` can be generated without any data in `cicd_deployment_commits`. In dashboard, there are many SQLs using `cicd_deployment_commits` counting deployment related metrics.  ### What do you expect to happen I think all these SQLs should be checked and updated(if necessary). ### How to reproduce Open Grafana's config json files, and you'll find it. ### Anything else _No response_ ### Version main ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- 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]
