Dataset: Issues & Pull Requests
Entity: Pull Requests
Field ID: build_status
Type: Select list
Description: The state of the Continuous Integration (CI) as exposed by the code management platforms (e.g. GitHub, GitLab). Possible values are:
NONEno builds detectedIN_PROGRESSthe build is pending or currently runningFAILUREthe build failed to complete due to an error, a timeout or because it was cancelledSUCCESSthe build completed successfully or was skippedACTION_REQUIREDthe build requires a manual action from the user
Source: App
Transformation logic: N/A
From: |
|
Github (PRs) |
Mapping:
|
Gitlab (PRs) |
Mapping:
|
Bitbucket (PRs) |
Mapping:
|
Azure DevOps (PRs, Issues) |
When a commit has several statuses, the returned status is based on the order of precedence below ("rollup status").
Mapping by order of precedence:
|
JIRA (Issues) | N/A |
ClickUp (Issues) | N/A |
Trello (Issues) | N/A |
Reporting Use Cases
The Build Status field is critical for monitoring the health of your CI/CD pipeline and enforcing quality standards. As a text field with a fixed set of values, it is ideal for filtering, creating compliance metrics, and analyzing the stability of your codebase.
Filtering and Triage: You can quickly identify pull requests that require immediate attention based on their build outcome.
Identify Broken Builds: Create a high-priority list of open pull requests that need to be fixed by using a filter like
Build Status= "FAILURE".Compliance Audits: You can audit your merge practices by creating a report of all merged pull requests that had a failing build at the time of merge. This is done by filtering where
State = "MERGED"andBuild Status = "FAILURE".Find Ready-to-Merge PRs: Combine with other fields to find pull requests that are approved and have a successful build, and are therefore ready to be merged:
Build Status = "SUCCESS" and Review State = "APPROVED".
Reporting and Trend Analysis: Using
Build Statusas a dimension allows you to visualize the health of your CI/CD pipeline over time.Build Outcome Distribution: A pie chart with
Build Statusas the dimension andCOUNT()as the metric can show you the proportion of successful, failed, and in-progress builds across all your pull requests.Failure Rate Over Time: Track the stability of your codebase with a line chart that uses a time-based dimension (e.g.,
YEAR_MONTH(created_at)) and a metric that counts only the failures:COUNT_IF(build_status == "FAILURE"). A rising trend could indicate a growing problem with technical debt or testing.
Custom Formulas and KPIs: You can create powerful key performance indicators to measure the effectiveness of your testing and integration processes.
Green Build Ratio: One of the most important metrics you can build is the percentage of pull requests that are merged with a successful build. This can be calculated with a custom formula like:
ROUND(COUNT_IF(build_status == "SUCCESS") / COUNT() * 100, 2).
