diff options
| author | Kirill Rysin <[email protected]> | 2026-06-18 21:47:37 +0200 |
|---|---|---|
| committer | GitHub <[email protected]> | 2026-06-18 22:47:37 +0300 |
| commit | 42b2c71601e033e050d6fa76d674a0ca2cc562a0 (patch) | |
| tree | efb11fc1990f44d244e6ea406311e053c8b8aa57 /.github/scripts/analytics/data_mart_queries/github_issues_timeline.sql | |
| parent | 8e6218277715bd372ab944a75b6a496292fe77cc (diff) | |
Export release:* labels to info.releaseblocker_state for BI (#43893)
Co-authored-by: Cursor <[email protected]>
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.sql | 2 |
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 |