You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@devlake.apache.org by ab...@apache.org on 2024/08/28 06:07:49 UTC
(incubator-devlake) branch release-v1.0 updated: fix: weekly bug retro panels support time range selected (#7972) (#7973)
This is an automated email from the ASF dual-hosted git repository.
abeizn pushed a commit to branch release-v1.0
in repository https://gitbox.apache.org/repos/asf/incubator-devlake.git
The following commit(s) were added to refs/heads/release-v1.0 by this push:
new f374b6920 fix: weekly bug retro panels support time range selected (#7972) (#7973)
f374b6920 is described below
commit f374b692053a06fbb179e335e0b2c423e809148b
Author: github-actions[bot] <41...@users.noreply.github.com>
AuthorDate: Wed Aug 28 14:07:45 2024 +0800
fix: weekly bug retro panels support time range selected (#7972) (#7973)
* fix: weekly bug retro panels support time range selected
* fix: lint
Co-authored-by: abeizn <zi...@merico.dev>
---
grafana/dashboards/WeeklyBugRetro.json | 15 ++++++++-------
1 file changed, 8 insertions(+), 7 deletions(-)
diff --git a/grafana/dashboards/WeeklyBugRetro.json b/grafana/dashboards/WeeklyBugRetro.json
index 6c4efb00f..3b1e9131e 100644
--- a/grafana/dashboards/WeeklyBugRetro.json
+++ b/grafana/dashboards/WeeklyBugRetro.json
@@ -18,6 +18,7 @@
"editable": true,
"fiscalYearStartMonth": 0,
"graphTooltip": 0,
+ "id": 49,
"links": [],
"liveNow": false,
"panels": [
@@ -563,7 +564,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select\n count(distinct i.id)\nfrom\n issues as i\n join 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 i.created_date BETWEEN curdate() - INTERVAL WEEKDAY(curdate())+7 DAY AND curdate() - INTERVAL WEEKDAY(curdate()) DAY\n and b.id in (${board_id})",
+ "rawSql": "select\n count(distinct i.id)\nfrom\n issues as i\n join 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 b.id in (${board_id})\n AND i.created_date BETWEEN \n DATE_SUB(FROM_UNIXTIME($__to / 1000), INTERVAL WEEKDAY(FROM_UNIXTIME($__to / 1000))+7 DAY)\n AND \n DATE_SUB(FROM_UNIXTIME($__to / 1000), INTERVAL WEEKDAY(FROM_UNIXTIME($__to / 1000)) DAY)",
"refId": "A",
"select": [
[
@@ -675,7 +676,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select\n priority,\n count(distinct i.id) as 'Issue Number'\nfrom\n issues as i\n join 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 i.created_date BETWEEN curdate() - INTERVAL WEEKDAY(curdate())+7 DAY AND curdate() - INTERVAL WEEKDAY(curdate()) DAY\n and b.id in (${board_id})\ngroup by 1",
+ "rawSql": "select\n priority,\n count(distinct i.id) as 'Issue Number'\nfrom\n issues as i\n join 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 b.id in (${board_id})\n AND i.created_date BETWEEN \n DATE_SUB(FROM_UNIXTIME($__to / 1000), INTERVAL WEEKDAY(FROM_UNIXTIME($__to / 1000))+7 DAY)\n AND \n DATE_SUB(FROM_UNIXTIME($__to / 1000), INTERVAL WEEKDAY(FROM_UNIXTIME($__to / 1000)) DAY)\ngroup by 1",
"refId": "A",
"select": [
[
@@ -834,7 +835,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',\n i.creator_name as 'Creator'\nfrom\n 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 i.created_date BETWEEN curdate() - INTERVAL WEEKDAY(curdate())+7 DAY AND curdate() - INTERVAL WEEKDAY(curdate()) DAY\n and b.id in (${board_id})",
+ "rawSql": "select\n i.issue_key as 'Issue Number',\n i.title as 'Title',\n i.url as 'Url',\n i.creator_name as 'Creator'\nfrom\n 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 b.id in (${board_id})\n AND i.created_date BETWEEN \n DATE_SUB(FROM_UNIXTIME($__to / 1000), INTERVAL WEEKDAY(FROM_UNIXTIME($__to / 1000))+7 DAY)\n AND \n DATE_SUB(FROM_UNIXTIME($__to / 1000), INTERVAL [...]
"refId": "A",
"select": [
[
@@ -943,7 +944,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select\n count(distinct i.id)\nfrom\n 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 i.resolution_date BETWEEN curdate() - INTERVAL WEEKDAY(curdate())+7 DAY AND curdate() - INTERVAL WEEKDAY(curdate()) DAY\n and b.id in (${board_id})",
+ "rawSql": "select\n count(distinct i.id)\nfrom\n 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 b.id in (${board_id})\n AND i.resolution_date BETWEEN \n DATE_SUB(FROM_UNIXTIME($__to / 1000), INTERVAL WEEKDAY(FROM_UNIXTIME($__to / 1000))+7 DAY)\n AND \n DATE_SUB(FROM_UNIXTIME($__to / 1000), INTERVAL WEEKDAY(FROM_UNIXTIME($__to / 1000)) DAY)",
"refId": "A",
"select": [
[
@@ -1057,7 +1058,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select\n avg(lead_time_minutes / 1440)\nfrom\n 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 i.resolution_date BETWEEN curdate() - INTERVAL WEEKDAY(curdate())+7 DAY AND curdate() - INTERVAL WEEKDAY(curdate()) DAY\n and b.id in (${board_id})",
+ "rawSql": "select\n avg(lead_time_minutes / 1440)\nfrom\n 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 b.id in (${board_id})\n AND i.resolution_date BETWEEN \n DATE_SUB(FROM_UNIXTIME($__to / 1000), INTERVAL WEEKDAY(FROM_UNIXTIME($__to / 1000))+7 DAY)\n AND \n DATE_SUB(FROM_UNIXTIME($__to / 1000), INTERVAL WEEKDAY(FROM_UNIXTIME($__to / 1000)) DAY)",
"refId": "A",
"select": [
[
@@ -1230,7 +1231,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select\n i.issue_key as 'Issue Number',\n i.title as 'Title',\n lead_time_minutes/1440 as 'Lead Time in Days',\n i.url as 'Url'\nfrom\n 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 i.resolution_date BETWEEN curdate() - INTERVAL WEEKDAY(curdate())+7 DAY AND curdate() - INTERVAL WEEKDAY(curdate()) DAY\n and b.id in (${board_id})",
+ "rawSql": "select\n i.issue_key as 'Issue Number',\n i.title as 'Title',\n lead_time_minutes/1440 as 'Lead Time in Days',\n i.url as 'Url'\nfrom\n 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 b.id in (${board_id})\n AND i.resolution_date BETWEEN \n DATE_SUB(FROM_UNIXTIME($__to / 1000), INTERVAL WEEKDAY(FROM_UNIXTIME($__to / 1000))+7 DAY)\n AND \n DA [...]
"refId": "A",
"select": [
[
@@ -1370,7 +1371,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 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 i.resolution_date BETWEEN curdate() - INTERVAL WEEKDAY(curdate())+7 DAY AND curdate() - INTERVAL WEEKDAY(curdate()) DAY\n and b.id in (${board_id})\norder by lead_time desc\nlimit 10",
+ "rawSql": "select\n concat('#',i.issue_key, ' ', i.title) as issue_key,\n lead_time_minutes/1440 as lead_time\nfrom\n 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 b.id in (${board_id})\n AND i.resolution_date BETWEEN \n DATE_SUB(FROM_UNIXTIME($__to / 1000), INTERVAL WEEKDAY(FROM_UNIXTIME($__to / 1000))+7 DAY)\n AND \n DATE_SUB(FROM_UNIXTIME($__to / 10 [...]
"refId": "A",
"select": [
[