Cycle
All cycles accessible to the user.
Table-Specific Information
SELECT
The connector uses the Linear API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the connector.| Column | Supported Operators |
| id | =, !=, IN, NOT IN |
| createdAt | =, !=, IN, NOT IN, <, <=, >, >= |
| updatedAt | =, !=, IN, NOT IN, <, <=, >, >= |
| number | =, !=, IN, NOT IN, <, <=, >, >= |
| name | =, !=, IN, NOT IN, LIKE, CONTAINS |
| startsAt | =, !=, IN, NOT IN, <, <=, >, >= |
| endsAt | =, !=, IN, NOT IN, <, <=, >, >= |
| completedAt | =, !=, IN, NOT IN, <, <=, >, >= |
| teamId | =, !=, IN, NOT IN |
| isActive | =, != |
| isFuture | =, != |
| isPast | =, != |
| isNext | =, != |
| isPrevious | =, != |
For example, the following queries are processed server-side:
SELECT * FROM Cycle LIMIT 1
SELECT * FROM Cycle WHERE number = 1 LIMIT 1
UPDATE
To update a Cycle record:UPDATE Cycle SET name = 'Sprint 12' WHERE id = '921cb6bf-d5b6-44bb-9c6b-217b97dd27a2'
Columns
| Name | Type | ReadOnly | Description |
| id [KEY] | String | True |
The unique identifier of the entity. |
| createdAt | Datetime | True |
The time at which the entity was created. |
| updatedAt | Datetime | True |
The last time at which the entity was meaningfully updated. This is the same as the creation time if the entity hasn't been updated after creation. |
| archivedAt | Datetime | True |
The time at which the entity was archived. Null if the entity has not been archived. |
| number | Double | True |
The auto-incrementing number of the cycle, unique within its team. This value is assigned automatically by the database and cannot be set on creation. |
| name | String | False |
The custom name of the cycle. If not set, the cycle is displayed using its number (e.g., |
| description | String | False |
The description of the cycle. |
| startsAt | Datetime | False |
The start date and time of the cycle. |
| endsAt | Datetime | False |
The end date and time of the cycle. When a cycle is completed prematurely, this is updated to match the completion time. When cycles are disabled, both endsAt and completedAt are set to the current time. |
| completedAt | Datetime | False |
The completion time of the cycle. If null, the cycle has not been completed yet. A cycle is completed either when its end date passes or when it is manually completed early. |
| autoArchivedAt | Datetime | True |
The time at which the cycle was automatically archived by the auto-pruning process. Null if the cycle has not been auto-archived. |
| issueCountHistory | String | True |
The total number of issues in the cycle after each day. Each entry represents a snapshot at the end of that day, forming the basis for burndown charts. Returned as a JSON array of Float values; accepts a JSON array or a comma-separated list when written. |
| completedIssueCountHistory | String | True |
The number of completed issues in the cycle after each day. Each entry corresponds to the same day index as issueCountHistory. Returned as a JSON array of Float values; accepts a JSON array or a comma-separated list when written. |
| scopeHistory | String | True |
The total number of estimation points (scope) in the cycle after each day. Used for scope-based burndown charts. Returned as a JSON array of Float values; accepts a JSON array or a comma-separated list when written. |
| completedScopeHistory | String | True |
The number of completed estimation points after each day. Used together with scopeHistory for burndown charts. Returned as a JSON array of Float values; accepts a JSON array or a comma-separated list when written. |
| inProgressScopeHistory | String | True |
The number of in-progress estimation points after each day. Tracks work that has been started but not yet completed. Returned as a JSON array of Float values; accepts a JSON array or a comma-separated list when written. |
| teamId | String | True |
The team that the cycle belongs to. Each cycle is scoped to exactly one team. |
| progressHistory | String | True |
[Internal] The detailed progress history of the cycle, including per-status breakdowns over time. |
| currentProgress | String | True |
[Internal] The current progress snapshot of the cycle, broken down by issue status categories. |
| inheritedFromId | String | True |
The parent cycle this cycle was inherited from. When a parent team creates cycles, sub-teams automatically receive corresponding inherited cycles. |
| isActive | Bool | True |
Whether the cycle is currently active. A cycle is active if the current time is between its start and end dates and it has not been completed. |
| isFuture | Bool | True |
Whether the cycle has not yet started. True if the cycle's start date is in the future. |
| isPast | Bool | True |
Whether the cycle's end date has passed. |
| progress | Double | True |
The overall progress of the cycle as a number between 0 and 1. Calculated as (completed estimate points + 0.25 * in-progress estimate points) / total estimate points. Returns 0 if no estimate points exist. |
| isNext | Bool | True |
Whether this cycle is the next upcoming (not yet started) cycle for the team. |
| isPrevious | Bool | True |
Whether this cycle is the most recently completed cycle for the team. |