This is an automated email from the ASF dual-hosted git repository.
yumeng 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 0004a52d fix: some live demo can not show
0004a52d is described below
commit 0004a52dc4b15a99d75c91dd96ca48607c3b6b98
Author: abeizn <[email protected]>
AuthorDate: Mon Oct 10 16:26:11 2022 +0800
fix: some live demo can not show
---
grafana/dashboards/WeeklyBugRetro.json | 32 ++++++++++++++++----------------
1 file changed, 16 insertions(+), 16 deletions(-)
diff --git a/grafana/dashboards/WeeklyBugRetro.json
b/grafana/dashboards/WeeklyBugRetro.json
index 597a0581..29ae9dfa 100644
--- a/grafana/dashboards/WeeklyBugRetro.json
+++ b/grafana/dashboards/WeeklyBugRetro.json
@@ -15,8 +15,8 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 15,
- "iteration": 1660821861545,
+ "id": 14,
+ "iteration": 1665388367641,
"links": [],
"panels": [
{
@@ -96,7 +96,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select\n count(*)\nfrom\n lake.issues as i\n join
lake.board_issues bi on i.id = bi.issue_id\n join boards b on bi.board_id =
b.id\nwhere\n type in ($issue_type)\n and date(i.created_date) BETWEEN
curdate() - INTERVAL WEEKDAY(curdate())+7 DAY AND curdate() - INTERVAL
WEEKDAY(curdate())+1 DAY\n and b.id in ($repo_id)",
+ "rawSql": "select\n count(*)\nfrom\n lake.issues as i\n join
lake.board_issues bi on i.id = bi.issue_id\n join boards b on bi.board_id =
b.id\nwhere\n i.type in ($issue_type)\n and date(i.created_date) BETWEEN
curdate() - INTERVAL WEEKDAY(curdate())+7 DAY AND curdate() - INTERVAL
WEEKDAY(curdate())+1 DAY\n and b.id in ($repo_id)",
"refId": "A",
"select": [
[
@@ -179,7 +179,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select\n case when component != '' then component else
'Issue-without-component' end as component,\n count(*) as 'Issue
Number'\nfrom\n lake.issues as i\n join lake.board_issues bi on i.id =
bi.issue_id\n join boards b on bi.board_id = b.id\nwhere\n type in
($issue_type)\n and date(i.created_date) BETWEEN curdate() - INTERVAL
WEEKDAY(curdate())+7 DAY AND curdate() - INTERVAL WEEKDAY(curdate())+1 DAY\n
and b.id in ($repo_id)\ngroup by 1",
+ "rawSql": "select\n case when component != '' then component else
'Issue-without-component' end as component,\n count(*) as 'Issue
Number'\nfrom\n lake.issues as i\n join lake.board_issues bi on i.id =
bi.issue_id\n join boards b on bi.board_id = b.id\nwhere\n i.type in
($issue_type)\n and date(i.created_date) BETWEEN curdate() - INTERVAL
WEEKDAY(curdate())+7 DAY AND curdate() - INTERVAL WEEKDAY(curdate())+1 DAY\n
and b.id in ($repo_id)\ngroup by 1",
"refId": "A",
"select": [
[
@@ -331,7 +331,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select\n i.issue_key as 'Issue Number',\n i.title as
'Title',\n i.url as 'Url'\nfrom\n lake.issues as i\n\tjoin lake.board_issues
bi on i.id = bi.issue_id\n\tjoin lake.boards b on bi.board_id = b.id\nwhere\n
type in ($issue_type)\n and date(i.created_date) BETWEEN curdate() - INTERVAL
WEEKDAY(curdate())+7 DAY AND curdate() - INTERVAL WEEKDAY(curdate())+1 DAY\n
and b.id in ($repo_id)",
+ "rawSql": "select\n i.issue_key as 'Issue Number',\n i.title as
'Title',\n i.url as 'Url'\nfrom\n lake.issues as i\n\tjoin lake.board_issues
bi on i.id = bi.issue_id\n\tjoin lake.boards b on bi.board_id = b.id\nwhere\n
i.type in ($issue_type)\n and date(i.created_date) BETWEEN curdate() -
INTERVAL WEEKDAY(curdate())+7 DAY AND curdate() - INTERVAL WEEKDAY(curdate())+1
DAY\n and b.id in ($repo_id)",
"refId": "A",
"select": [
[
@@ -412,7 +412,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select\n count(*)\nfrom\n lake.issues as i\n join
board_issues bi on i.id = bi.issue_id\n\tjoin boards b on bi.board_id =
b.id\nwhere\n type in ($issue_type)\n and status = 'DONE'\n and
date(i.resolution_date) BETWEEN curdate() - INTERVAL WEEKDAY(curdate())+7 DAY
AND curdate() - INTERVAL WEEKDAY(curdate())+1 DAY\n and b.id in ($repo_id)",
+ "rawSql": "select\n count(*)\nfrom\n lake.issues as i\n join
board_issues bi on i.id = bi.issue_id\n\tjoin boards b on bi.board_id =
b.id\nwhere\n i.type in ($issue_type)\n and status = 'DONE'\n and
date(i.resolution_date) BETWEEN curdate() - INTERVAL WEEKDAY(curdate())+7 DAY
AND curdate() - INTERVAL WEEKDAY(curdate())+1 DAY\n and b.id in ($repo_id)",
"refId": "A",
"select": [
[
@@ -498,7 +498,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select\n avg(lead_time_minutes / 1440)\nfrom\n
lake.issues as i\n\tjoin board_issues bi on i.id = bi.issue_id\n\tjoin boards b
on bi.board_id = b.id\nwhere\n type in ($issue_type)\n and status = 'DONE'\n
and date(i.resolution_date) BETWEEN curdate() - INTERVAL WEEKDAY(curdate())+7
DAY AND curdate() - INTERVAL WEEKDAY(curdate())+1 DAY\n and b.id in
($repo_id)",
+ "rawSql": "select\n avg(lead_time_minutes / 1440)\nfrom\n
lake.issues as i\n\tjoin board_issues bi on i.id = bi.issue_id\n\tjoin boards b
on bi.board_id = b.id\nwhere\n i.type in ($issue_type)\n and status =
'DONE'\n and date(i.resolution_date) BETWEEN curdate() - INTERVAL
WEEKDAY(curdate())+7 DAY AND curdate() - INTERVAL WEEKDAY(curdate())+1 DAY\n
and b.id in ($repo_id)",
"refId": "A",
"select": [
[
@@ -639,7 +639,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select\n i.issue_key as 'Issue Number',\n i.title as
'Title',\n i.url as 'Url'\nfrom\n lake.issues as i\n\tjoin board_issues bi on
i.id = bi.issue_id\n\tjoin boards b on bi.board_id = b.id\nwhere\n type in
($issue_type)\n and status = 'DONE'\n and date(i.resolution_date) BETWEEN
curdate() - INTERVAL WEEKDAY(curdate())+7 DAY AND curdate() - INTERVAL
WEEKDAY(curdate())+1 DAY\n and b.id in ($repo_id)",
+ "rawSql": "select\n i.issue_key as 'Issue Number',\n i.title as
'Title',\n i.url as 'Url'\nfrom\n lake.issues as i\n\tjoin board_issues bi on
i.id = bi.issue_id\n\tjoin boards b on bi.board_id = b.id\nwhere\n i.type in
($issue_type)\n and status = 'DONE'\n and date(i.resolution_date) BETWEEN
curdate() - INTERVAL WEEKDAY(curdate())+7 DAY AND curdate() - INTERVAL
WEEKDAY(curdate())+1 DAY\n and b.id in ($repo_id)",
"refId": "A",
"select": [
[
@@ -736,7 +736,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select\n concat('#',i.issue_key, ' ', i.title) as
issue_key,\n lead_time_minutes/1440 as lead_time\nfrom\n lake.issues as
i\n\tjoin board_issues bi on i.id = bi.issue_id\n\tjoin boards b on bi.board_id
= b.id\nwhere\n type in ($issue_type)\n and status = 'DONE'\n and
date(i.resolution_date) BETWEEN curdate() - INTERVAL WEEKDAY(curdate())+7 DAY
AND curdate() - INTERVAL WEEKDAY(curdate())+1 DAY\n and b.id in
($repo_id)\norder by lead_time desc",
+ "rawSql": "select\n concat('#',i.issue_key, ' ', i.title) as
issue_key,\n lead_time_minutes/1440 as lead_time\nfrom\n lake.issues as
i\n\tjoin board_issues bi on i.id = bi.issue_id\n\tjoin boards b on bi.board_id
= b.id\nwhere\n i.type in ($issue_type)\n and status = 'DONE'\n and
date(i.resolution_date) BETWEEN curdate() - INTERVAL WEEKDAY(curdate())+7 DAY
AND curdate() - INTERVAL WEEKDAY(curdate())+1 DAY\n and b.id in
($repo_id)\norder by lead_time desc",
"refId": "A",
"select": [
[
@@ -817,7 +817,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select\n count(*)\nfrom \n lake.issues i\n\tjoin
board_issues bi on i.id = bi.issue_id\n\tjoin boards b on bi.board_id =
b.id\nwhere\n type in ($issue_type)\n and i.status != 'DONE'\n and b.id in
($repo_id)",
+ "rawSql": "select\n count(*)\nfrom \n lake.issues i\n\tjoin
board_issues bi on i.id = bi.issue_id\n\tjoin boards b on bi.board_id =
b.id\nwhere\n i.type in ($issue_type)\n and i.status != 'DONE'\n and b.id in
($repo_id)",
"refId": "A",
"select": [
[
@@ -898,7 +898,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select \n avg((TIMESTAMPDIFF(MINUTE,
i.created_date,NOW()))/1440)\nfrom \n lake.issues i\n\tjoin board_issues bi on
i.id = bi.issue_id\n\tjoin boards b on bi.board_id = b.id\nwhere\n type in
($issue_type)\n and i.status != 'DONE'\n and b.id in ($repo_id)",
+ "rawSql": "select \n avg((TIMESTAMPDIFF(MINUTE,
i.created_date,NOW()))/1440)\nfrom \n lake.issues i\n\tjoin board_issues bi on
i.id = bi.issue_id\n\tjoin boards b on bi.board_id = b.id\nwhere\n i.type in
($issue_type)\n and i.status != 'DONE'\n and b.id in ($repo_id)",
"refId": "A",
"select": [
[
@@ -1159,7 +1159,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select \n concat('#', i.issue_key, ' ', i.title) as
issue_key,\n (TIMESTAMPDIFF(MINUTE, i.created_date,NOW()))/1440 as 'Queue Time
in Days'\nfrom \n lake.issues i\n\tjoin board_issues bi on i.id =
bi.issue_id\n\tjoin boards b on bi.board_id = b.id\nwhere\n type in
($issue_type)\n and i.status != 'DONE'\n and b.id in ($repo_id)\norder by 2
desc",
+ "rawSql": "select \n concat('#', i.issue_key, ' ', i.title) as
issue_key,\n (TIMESTAMPDIFF(MINUTE, i.created_date,NOW()))/1440 as 'Queue Time
in Days'\nfrom \n lake.issues i\n\tjoin board_issues bi on i.id =
bi.issue_id\n\tjoin boards b on bi.board_id = b.id\nwhere\n i.type in
($issue_type)\n and i.status != 'DONE'\n and b.id in ($repo_id)\norder by 2
desc",
"refId": "A",
"select": [
[
@@ -1254,7 +1254,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "with bugs as ( \n select \n
DATE_ADD(date(i.created_date), INTERVAL -WEEKDAY(date(i.created_date)) DAY) as
time,\n count(*) as bug_count\n from\n lake.issues as i\n\t join
lake.board_issues bi on i.id = bi.issue_id\n\t join lake.boards b on
bi.board_id = b.id\n where \n type in ($issue_type)\n and
$__timeFilter(i.created_date)\n and b.id in ($repo_id)\n group by time\n
order by time desc\n),\n\ncalendar_date as(\n\tSELECT CAST((SYSDATE()-INT [...]
+ "rawSql": "with bugs as ( \n select \n
DATE_ADD(date(i.created_date), INTERVAL -WEEKDAY(date(i.created_date)) DAY) as
time,\n count(*) as bug_count\n from\n lake.issues as i\n\t join
lake.board_issues bi on i.id = bi.issue_id\n\t join lake.boards b on
bi.board_id = b.id\n where \n i.type in ($issue_type)\n and
$__timeFilter(i.created_date)\n and b.id in ($repo_id)\n group by time\n
order by time desc\n),\n\ncalendar_date as(\n\tSELECT CAST((SYSDATE()-I [...]
"refId": "A",
"select": [
[
@@ -1349,7 +1349,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "with bugs as (\n select \n
DATE_ADD(date(i.resolution_date), INTERVAL -WEEKDAY(date(i.resolution_date))
DAY) as time,\n count(*) as bug_count\n from\n lake.issues as i\n\t
join lake.board_issues bi on i.id = bi.issue_id\n\t join lake.boards b on
bi.board_id = b.id\n where \n type in ($issue_type)\n and status =
'DONE'\n and $__timeFilter(i.resolution_date)\n and b.id in ($repo_id)\n
group by time\n order by time desc\n),\n\ncalendar_date a [...]
+ "rawSql": "with bugs as (\n select \n
DATE_ADD(date(i.resolution_date), INTERVAL -WEEKDAY(date(i.resolution_date))
DAY) as time,\n count(*) as bug_count\n from\n lake.issues as i\n\t
join lake.board_issues bi on i.id = bi.issue_id\n\t join lake.boards b on
bi.board_id = b.id\n where \n i.type in ($issue_type)\n and status =
'DONE'\n and $__timeFilter(i.resolution_date)\n and b.id in ($repo_id)\n
group by time\n order by time desc\n),\n\ncalendar_date [...]
"refId": "A",
"select": [
[
@@ -1446,7 +1446,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "with calendar_date as(\n\tSELECT CAST((SYSDATE()-INTERVAL
(H+T+U) DAY) AS date) d\n\tFROM ( SELECT 0 H\n\t\t\tUNION ALL SELECT 100 UNION
ALL SELECT 200 UNION ALL SELECT 300\n\t\t) H CROSS JOIN ( SELECT 0
T\n\t\t\tUNION ALL SELECT 10 UNION ALL SELECT 20 UNION ALL SELECT
30\n\t\t\tUNION ALL SELECT 40 UNION ALL SELECT 50 UNION ALL SELECT
60\n\t\t\tUNION ALL SELECT 70 UNION ALL SELECT 80 UNION ALL SELECT 90\n\t\t)
T CROSS JOIN ( SELECT 0 U\n\t\t\tUNION ALL SELEC [...]
+ "rawSql": "with calendar_date as(\n\tSELECT CAST((SYSDATE()-INTERVAL
(H+T+U) DAY) AS date) d\n\tFROM ( SELECT 0 H\n\t\t\tUNION ALL SELECT 100 UNION
ALL SELECT 200 UNION ALL SELECT 300\n\t\t) H CROSS JOIN ( SELECT 0
T\n\t\t\tUNION ALL SELECT 10 UNION ALL SELECT 20 UNION ALL SELECT
30\n\t\t\tUNION ALL SELECT 40 UNION ALL SELECT 50 UNION ALL SELECT
60\n\t\t\tUNION ALL SELECT 70 UNION ALL SELECT 80 UNION ALL SELECT 90\n\t\t)
T CROSS JOIN ( SELECT 0 U\n\t\t\tUNION ALL SELEC [...]
"refId": "A",
"select": [
[
@@ -1559,5 +1559,5 @@
"timezone": "",
"title": "Weekly Bug Retro",
"uid": "-5EKA5w7k",
- "version": 3
+ "version": 14
}
\ No newline at end of file
