ADO.NET Provider for Linear

Build 26.0.9776

Cycle

All cycles accessible to the user.

Table-Specific Information

SELECT

The provider 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 provider.

ColumnSupported 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.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9776