This is an automated email from the ASF dual-hosted git repository.
abeizn pushed a commit to branch release-v0.20
in repository https://gitbox.apache.org/repos/asf/incubator-devlake.git
The following commit(s) were added to refs/heads/release-v0.20 by this push:
new e50e91bf6 fix: PR Size is getting duplicated when using query from the
document… (#6661)
e50e91bf6 is described below
commit e50e91bf6a5843945213c2e5428e0b6a825a8098
Author: naveenreddymanukonda
<[email protected]>
AuthorDate: Wed Dec 20 17:27:29 2023 +0530
fix: PR Size is getting duplicated when using query from the document…
(#6661)
* FIX: PR Size is getting duplicated when using query from the
documentation given #6651
* FIX: PR Size is getting duplicated when using query from the
documentation given #6651
* FIX: PR Size is getting duplicated when using query from the
documentation given #6651
---------
Co-authored-by: Naveen Manukonda <[email protected]>
---
grafana/dashboards/EngineeringThroughputAndCycleTime.json | 4 ++--
grafana/dashboards/EngineeringThroughputAndCycleTimeTeamView.json | 2 +-
2 files changed, 3 insertions(+), 3 deletions(-)
diff --git a/grafana/dashboards/EngineeringThroughputAndCycleTime.json
b/grafana/dashboards/EngineeringThroughputAndCycleTime.json
index 8d9218def..5511a8af4 100644
--- a/grafana/dashboards/EngineeringThroughputAndCycleTime.json
+++ b/grafana/dashboards/EngineeringThroughputAndCycleTime.json
@@ -734,7 +734,7 @@
"hide": false,
"metricColumn": "none",
"rawQuery": true,
- "rawSql": "with _pr_commits_data as(\n SELECT\n
DATE_ADD(date(pr.created_date), INTERVAL -$interval(date(pr.created_date))+1
DAY) as time,\n pr.id as pr_id,\n prc.commit_sha,\n
sum(c.additions)+sum(c.deletions) as loc\n FROM \n pull_requests pr\n
left join pull_request_commits prc on pr.id = prc.pull_request_id\n left
join commits c on prc.commit_sha = c.sha\n join project_mapping pm on
pr.base_repo_id = pm.row_id and pm.table = 'repos' \n WHERE\n [...]
+ "rawSql": "with _pr_commits_data as(\n SELECT\n
DATE_ADD(date(pr.created_date), INTERVAL -$interval(date(pr.created_date))+1
DAY) as time,\n pr.id as pr_id,\n pr.merge_commit_sha,\n
sum(c.additions)+sum(c.deletions) as loc\n FROM \n pull_requests pr\n left
join commits c on pr.merge_commit_sha = c.sha\n join project_mapping pm on
pr.base_repo_id = pm.row_id and pm.table = 'repos' \n WHERE\n
$__timeFilter(pr.created_date)\n and pm.project_name in ($pro [...]
"refId": "A",
"select": [
[
@@ -1649,4 +1649,4 @@
"title": "Engineering Throughput and Cycle Time",
"uid": "Jaaimc67k",
"version": 3
-}
\ No newline at end of file
+}
\ No newline at end of file
diff --git a/grafana/dashboards/EngineeringThroughputAndCycleTimeTeamView.json
b/grafana/dashboards/EngineeringThroughputAndCycleTimeTeamView.json
index 0ffd9d007..c6c484ebc 100644
--- a/grafana/dashboards/EngineeringThroughputAndCycleTimeTeamView.json
+++ b/grafana/dashboards/EngineeringThroughputAndCycleTimeTeamView.json
@@ -1451,7 +1451,7 @@
"hide": false,
"metricColumn": "none",
"rawQuery": true,
- "rawSql": "with _prs as(\n SELECT\n pr.id,\n pr.url,\n
pr.created_date,\n pr.merged_date,\n pr.author_id,\n prc.commit_sha,\n
c.additions + c.deletions as loc,\n u.id as user_id,\n u.name as
user_name,\n t.id as team_id,\n t.name as team\n FROM pull_requests pr\n
join project_mapping pm on pr.base_repo_id = pm.row_id and pm.table =
'repos' \n left join pull_request_commits prc on pr.id =
prc.pull_request_id\n left join commits c on pr [...]
+ "rawSql": "with _prs as(\n SELECT\n pr.id,\n pr.url,\n
pr.created_date,\n pr.merged_date,\n pr.author_id,\n
pr.merge_commit_sha,\n c.additions + c.deletions as loc,\n u.id as
user_id,\n u.name as user_name,\n t.id as team_id,\n t.name as team\n
FROM pull_requests pr\n join project_mapping pm on pr.base_repo_id =
pm.row_id and pm.table = 'repos' \n left join commits c on
pr.merge_commit_sha = c.sha\n join user_accounts ua on pr.author_i [...]
"refId": "A",
"select": [
[
