This is an automated email from the ASF dual-hosted git repository.
abeizn 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 7fbb0cc95 fix: sonaqube dashboard fix (#4583)
7fbb0cc95 is described below
commit 7fbb0cc95c23b23456f754a615766d5d2bad7ddf
Author: mappjzc <[email protected]>
AuthorDate: Mon Mar 6 14:17:36 2023 +0800
fix: sonaqube dashboard fix (#4583)
SonaQube Dashboard fixing.
Nddtfjiang <[email protected]>
---
grafana/dashboards/Sonarqube.json | 20 ++++++++++----------
1 file changed, 10 insertions(+), 10 deletions(-)
diff --git a/grafana/dashboards/Sonarqube.json
b/grafana/dashboards/Sonarqube.json
index 34bf9abad..9d5443964 100644
--- a/grafana/dashboards/Sonarqube.json
+++ b/grafana/dashboards/Sonarqube.json
@@ -88,7 +88,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "SELECT\n count(*) as 'Bugs'\nFROM cq_issues\nWHERE\n
$__timeFilter(creation_date)\n and project_key in ($project_id)\n and `type`
= 'BUG'\nORDER BY creation_date",
+ "rawSql": "SELECT\n count(*) as 'Bugs'\nFROM cq_issues\nWHERE\n
$__timeFilter(created_date)\n and project_key in ($project_id)\n and `type` =
'BUG'\nORDER BY created_date",
"refId": "A",
"select": [
[
@@ -172,7 +172,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "SELECT\n count(*) as 'Vulnerabilities'\nFROM
cq_issues\nWHERE\n $__timeFilter(creation_date)\n and project_key in
($project_id)\n and `type` = 'VULNERABILITY'\nORDER BY creation_date",
+ "rawSql": "SELECT\n count(*) as 'Vulnerabilities'\nFROM
cq_issues\nWHERE\n $__timeFilter(created_date)\n and project_key in
($project_id)\n and `type` = 'VULNERABILITY'\nORDER BY created_date",
"refId": "A",
"select": [
[
@@ -256,7 +256,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "SELECT\n COUNT(IF(status = 'TO_REVIEW', 1, NULL)) AS
'Security Hotspots'\nFROM cq_issues\nWHERE\n $__timeFilter(creation_date)\n
and project_key in ($project_id)\n and `type` = 'HOTSPOTS'\nORDER BY
creation_date",
+ "rawSql": "SELECT\n COUNT(IF(status = 'TO_REVIEW', 1, NULL)) AS
'Security Hotspots'\nFROM cq_issues\nWHERE\n $__timeFilter(created_date)\n
and project_key in ($project_id)\n and `type` = 'HOTSPOTS'\nORDER BY
created_date",
"refId": "A",
"select": [
[
@@ -340,7 +340,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "SELECT\n CONCAT(ROUND(COUNT(IF(status != 'TO_REVIEW', 1,
NULL)) / COUNT(*) * 100, 2), '%') AS 'Reviewed'\nFROM cq_issues\nWHERE\n
$__timeFilter(creation_date)\n and project_key in ($project_id)\n and `type`
= 'HOTSPOTS'\nORDER BY creation_date",
+ "rawSql": "SELECT\n CONCAT(ROUND(COUNT(IF(status != 'TO_REVIEW', 1,
NULL)) / COUNT(*) * 100, 2), '%') AS 'Reviewed'\nFROM cq_issues\nWHERE\n
$__timeFilter(created_date)\n and project_key in ($project_id)\n and `type` =
'HOTSPOTS'\nORDER BY created_date",
"refId": "A",
"select": [
[
@@ -523,7 +523,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "SELECT\n CONCAT(ROUND(SUM(debt) / (8 * 60), 0), ' days')
AS 'Debt'\nFROM cq_issues\nWHERE\n $__timeFilter(creation_date)\n and
project_key in ($project_id)",
+ "rawSql": "SELECT\n CONCAT(ROUND(SUM(debt) / (8 * 60), 0), ' days')
AS 'Debt'\nFROM cq_issues\nWHERE\n $__timeFilter(created_date)\n and
project_key in ($project_id)",
"refId": "A",
"select": [
[
@@ -608,7 +608,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "SELECT\n\tCOUNT(if(type = 'CODE_SMELL', 1, null)) as
'Code Smells'\nFROM cq_issues\nWHERE\n $__timeFilter(creation_date)\n and
project_key in ($project_id)",
+ "rawSql": "SELECT\n\tCOUNT(if(type = 'CODE_SMELL', 1, null)) as
'Code Smells'\nFROM cq_issues\nWHERE\n $__timeFilter(created_date)\n and
project_key in ($project_id)",
"refId": "A",
"select": [
[
@@ -988,9 +988,9 @@
{
"allValue": null,
"current": {
- "selected": false,
- "text": "",
- "value": ""
+ "selected": true,
+ "text": "20",
+ "value": "20"
},
"description": null,
"error": null,
@@ -1001,7 +1001,7 @@
"name": "rows",
"options": [
{
- "selected": false,
+ "selected": true,
"text": "20",
"value": "20"
},
