This is an automated email from the ASF dual-hosted git repository.
klesh pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/incubator-devlake.git
The following commit(s) were added to refs/heads/main by this push:
new 6b391402 fix: some panels of grafana can not work (#1907)
6b391402 is described below
commit 6b391402c500225b0818ae4f573e984dbbc7ebe2
Author: abeizn <[email protected]>
AuthorDate: Thu May 19 11:42:22 2022 +0800
fix: some panels of grafana can not work (#1907)
---
.../GithubReleaseQualityAndContributionAnalysis.json | 20 ++++++++++----------
1 file changed, 10 insertions(+), 10 deletions(-)
diff --git
a/grafana/dashboards/GithubReleaseQualityAndContributionAnalysis.json
b/grafana/dashboards/GithubReleaseQualityAndContributionAnalysis.json
index de21713d..728c6073 100644
--- a/grafana/dashboards/GithubReleaseQualityAndContributionAnalysis.json
+++ b/grafana/dashboards/GithubReleaseQualityAndContributionAnalysis.json
@@ -16,7 +16,7 @@
"gnetId": null,
"graphTooltip": 0,
"id": 11,
- "iteration": 1650642496197,
+ "iteration": 1652845435719,
"links": [],
"panels": [
{
@@ -218,7 +218,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Get the number of fixed bugs in the last 5 tags\nwith
_last_5_tags as(\n SELECT \n distinct new_ref_id, old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 5\n),\n\n_bugs_of_tags as(\n\tselect
\n\t\tSUBSTRING_INDEX(rid.new_ref_id,'tags/', -1) as tag_name,
\n\t\tSUBSTRING_INDEX(rid.new_ref_id,':', 3) as repo_id,\n\t\tcount(*) as
bug_count\n\tfrom\n\t\trefs_issues_diffs rid\n\t\tl [...]
+ "rawSql": "-- Get the number of fixed bugs in the last 5 tags\nwith
_last_5_tags as(\n SELECT \n distinct new_ref_id, old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 5\n),\n\n_bugs_of_tags as(\n\tselect
\n\t\tSUBSTRING_INDEX(rid.new_ref_id,'tags/', -1) as tag_name,
\n\t\tSUBSTRING_INDEX(rid.new_ref_id,':', 3) as repo_id,\n\t\tcount(*) as
bug_count\n\tfrom\n\t\trefs_issues_diffs rid\n\t\tl [...]
"refId": "A",
"select": [
[
@@ -1829,7 +1829,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Get the work-type distribution in the last 5
tags\nwith _last_5_tags as(\n SELECT \n distinct new_ref_id, old_ref_id\n
FROM \n refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3)
in ($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 1\n),\n\n_combine_pr as (\n select
pull_request_id as id, commit_sha, p.`key` as `key` from pull_request_commits
left join pull_requests p on pull_request_commits.pull_request_id = p.id\n
where base_repo_id = ($repo_id)\n [...]
+ "rawSql": "-- Get the work-type distribution in the last 5
tags\nwith _last_5_tags as(\n SELECT \n distinct new_ref_id, old_ref_id\n
FROM \n refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3)
in ($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 1\n),\n\n_combine_pr as (\n select
pull_request_id as id, commit_sha, p.`key` as `key` from pull_request_commits
left join pull_requests p on pull_request_commits.pull_request_id = p.id\n
where base_repo_id in ($repo_id)\ [...]
"refId": "A",
"select": [
[
@@ -1914,7 +1914,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Get the work-type distribution in the last 5
tags\nwith _last_5_tags as(\n SELECT \n distinct new_ref_id, old_ref_id\n
FROM \n refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3)
in ($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 1,1\n),\n\n\n_combine_pr as (\n
select pull_request_id as id, commit_sha, p.`key` as `key` from
pull_request_commits left join pull_requests p on
pull_request_commits.pull_request_id = p.id\n where base_repo_id = ($repo_i
[...]
+ "rawSql": "-- Get the work-type distribution in the last 5
tags\nwith _last_5_tags as(\n SELECT \n distinct new_ref_id, old_ref_id\n
FROM \n refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3)
in ($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 1,1\n),\n\n\n_combine_pr as (\n
select pull_request_id as id, commit_sha, p.`key` as `key` from
pull_request_commits left join pull_requests p on
pull_request_commits.pull_request_id = p.id\n where base_repo_id in ($repo_
[...]
"refId": "A",
"select": [
[
@@ -2030,7 +2030,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Get the work-type distribution in the last 5
tags\nwith _last_5_tags as(\n SELECT \n distinct new_ref_id, old_ref_id\n
FROM \n refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3)
in ($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 2,1\n),\n\n\n_combine_pr as (\n
select pull_request_id as id, commit_sha, p.`key` as `key` from
pull_request_commits left join pull_requests p on
pull_request_commits.pull_request_id = p.id\n where base_repo_id = ($repo_i
[...]
+ "rawSql": "-- Get the work-type distribution in the last 5
tags\nwith _last_5_tags as(\n SELECT \n distinct new_ref_id, old_ref_id\n
FROM \n refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3)
in ($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 2,1\n),\n\n\n_combine_pr as (\n
select pull_request_id as id, commit_sha, p.`key` as `key` from
pull_request_commits left join pull_requests p on
pull_request_commits.pull_request_id = p.id\n where base_repo_id in ($repo_
[...]
"refId": "A",
"select": [
[
@@ -2248,12 +2248,12 @@
{
"allValue": null,
"current": {
- "selected": false,
+ "selected": true,
"text": [
- "ClickHouse/ClickHouse"
+ "All"
],
"value": [
- "github:GithubRepo:60246359"
+ "$__all"
]
},
"datasource": "mysql",
@@ -2283,5 +2283,5 @@
"timezone": "",
"title": "GitHub_Release_Quality_and_Contribution_Analysis",
"uid": "2xuOaQUnk1",
- "version": 51
-}
+ "version": 7
+}
\ No newline at end of file
