WorkflowRuns
Lists workflow runs for a repository.
Table-Specific Information
Select
The driver uses the GitHub API to process WHERE clause conditions that are built with the following columns and operators:
| Column | Supported Operators |
| Id | = |
| WorkflowId | = |
| HeadSha | = |
| HeadBranch | = |
| Actor | = |
| Event | = |
| Status | = |
| CheckSuiteId | = |
| CreatedAt | >=, >, =, <, <= |
| ExcludePullRequests | = |
For example, the following queries are processed server-side:
SELECT * FROM [WorkflowRuns]
SELECT * FROM [WorkflowRuns] WHERE [Id] = 123
SELECT * FROM [WorkflowRuns] WHERE [WorkflowId] = 123
SELECT * FROM [WorkflowRuns] WHERE [HeadSha] = 'Val1'
SELECT * FROM [WorkflowRuns] WHERE [HeadBranch] = 'Val1'
SELECT * FROM [WorkflowRuns] WHERE [Actor] = 'Val1'
SELECT * FROM [WorkflowRuns] WHERE [Event] = 'workflows'
SELECT * FROM [WorkflowRuns] WHERE [Status] = 'completed'
SELECT * FROM [WorkflowRuns] WHERE [CheckSuiteId] = 123
SELECT * FROM [WorkflowRuns] WHERE [CreatedAt] >= '2023-01-01 11:10:00'
SELECT * FROM [WorkflowRuns] WHERE [ExcludePullRequests] = true
The driver processes other filters client-side within the driver.
Delete
You can specify the following column to delete a record: Id
DELETE FROM [WorkflowRuns] WHERE [Id] = 123
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Long | True |
The unique numeric identifier of the workflow run. | |
| NodeId | String | True |
The GraphQL node ID of the workflow run. | |
| WorkflowId | Long | True |
Workflows.Id |
The numeric identifier of the workflow associated with this run. |
| Name | String | True |
The name of the workflow run, derived from the workflow name. | |
| DisplayTitle | String | True |
The user-facing title of the workflow run. | |
| HeadSha | String | True |
The commit SHA that triggered the workflow run. | |
| HeadBranch | String | True |
The branch that the workflow run was triggered on. | |
| HeadRepositoryId | Long | True |
The numeric identifier of the repository containing the head commit, which differs from the base repository when the run was triggered by a pull request from a fork. | |
| RunNumber | Long | True |
The sequential run number for this workflow run within the repository. | |
| RunAttempt | Long | True |
The number of attempts made for this workflow run, starting from 1. | |
| RunStartedAt | Datetime | True |
The date and time when the workflow run actually started executing. | |
| Actor | String | True |
The username of the user who triggered the workflow run. | |
| TriggeringActor | String | True |
The username of the user who originally triggered the workflow run. | |
| Event | String | True |
The event type that triggered the workflow run. The allowed values are workflows, branch_protection_rule, check_run, check_suite, create, delete, deployment, deployment_status, discussion, discussion_comment, fork, gollum, image_version, issue_comment, issues, label, merge_group, milestone, page_build, public, pull_request, pull_request_comment, pull_request_review, pull_request_review_comment, pull_request_target, push, registry_package, release, repository_dispatch, schedule, status, watch, workflow_call, workflow_dispatch, workflow_run, dynamic. | |
| Status | String | True |
The current status of the workflow run. The allowed values are completed, action_required, cancelled, failure, neutral, skipped, stale, success, timed_out, in_progress, queued, requested, waiting, pending. | |
| Conclusion | String | True |
The final result of a completed workflow run. | |
| CheckSuiteId | Long | True |
The numeric identifier of the check suite associated with this workflow run. | |
| CheckSuiteNodeId | String | True |
The GraphQL node ID of the check suite associated with this workflow run. | |
| CheckSuiteUrl | String | True |
The REST API URL for the associated check suite. | |
| Path | String | True |
The path to the workflow definition file that triggered this run. | |
| Url | String | True |
The REST API URL for accessing this workflow run. | |
| HtmlUrl | String | True |
The GitHub URL for viewing the workflow run in the browser. | |
| JobsUrl | String | True |
The REST API URL for listing the jobs associated with this workflow run. | |
| LogsUrl | String | True |
The REST API URL for downloading the log archive for this workflow run. | |
| ArtifactsUrl | String | True |
The REST API URL for listing the artifacts produced by this workflow run. | |
| CancelUrl | String | True |
The REST API URL for canceling this workflow run. | |
| RerunUrl | String | True |
The REST API URL for re-running this workflow run. | |
| WorkflowUrl | String | True |
The REST API URL for the workflow definition associated with this run. | |
| PreviousAttemptUrl | String | True |
The REST API URL of the previous attempted run of this workflow, if one exists. | |
| CreatedAt | Datetime | True |
The date and time when the workflow run was created. | |
| UpdatedAt | Datetime | True |
The date and time when the workflow run was last updated. | |
| ReferencedWorkflows | String | True |
Workflows referenced/reused by the caller. | |
| PullRequests | String | True |
Pull requests that are open with a 'head_sha' or 'head_branch' that matches the workflow run. | |
| ExcludePullRequests | Bool | True |
Indicates whether to exclude pull request runs from the results. |