From 42b2c71601e033e050d6fa76d674a0ca2cc562a0 Mon Sep 17 00:00:00 2001
From: Kirill Rysin <35688753+naspirato@users.noreply.github.com>
Date: Thu, 18 Jun 2026 21:47:37 +0200
Subject: Export release:* labels to info.releaseblocker_state for BI (#43893)

Co-authored-by: Cursor <cursoragent@cursor.com>
---
 .github/scripts/analytics/data_mart_queries/github_issues_timeline.sql | 2 ++
 1 file changed, 2 insertions(+)

(limited to '.github/scripts/analytics/data_mart_queries/github_issues_timeline.sql')

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
-- 
cgit v1.3

