summaryrefslogtreecommitdiffstats
path: root/.github/scripts/analytics/data_mart_queries/github_issues_timeline.sql
diff options
context:
space:
mode:
Diffstat (limited to '.github/scripts/analytics/data_mart_queries/github_issues_timeline.sql')
-rw-r--r--.github/scripts/analytics/data_mart_queries/github_issues_timeline.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/.github/scripts/analytics/data_mart_queries/github_issues_timeline.sql b/.github/scripts/analytics/data_mart_queries/github_issues_timeline.sql
index e2469b7d366..cbece481272 100644
--- a/.github/scripts/analytics/data_mart_queries/github_issues_timeline.sql
+++ b/.github/scripts/analytics/data_mart_queries/github_issues_timeline.sql
@@ -60,6 +60,7 @@ SELECT
i.max_branch AS max_branch,
i.env AS env,
i.priority AS priority,
+ i.releaseblocker_state AS releaseblocker_state,
i.branch AS branch,
i.area AS area,
CAST(
@@ -110,6 +111,7 @@ CROSS JOIN (
COALESCE(JSON_VALUE(t.info, "$.max_branch"), '-') AS max_branch,
COALESCE(JSON_VALUE(t.info, "$.env"), 'env:-') AS env,
COALESCE(JSON_VALUE(t.info, "$.priority"), 'priority:-') AS priority,
+ COALESCE(JSON_VALUE(t.info, "$.releaseblocker_state"), 'release:-') AS releaseblocker_state,
COALESCE(JSON_VALUE(t.info, "$.branch"), '-') AS branch,
Coalesce(m.matched_area,
CASE