[Bug][Dashboard] SQL statemente using `cicd_deloyment_commits` need to be checked and updated

[d4x1]

Search before asking

• I had searched in the issues 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

• I agree to follow this project's Code of Conduct

[github-actions]

This issue has been automatically marked as stale because it has been inactive for 60 days. It will be closed in next 7 days if no further activity occurs.

[github-actions]

This issue has been closed because it has been inactive for a long time. You can reopen it if you encounter the similar problem in the future.