ADO.NET Provider for Linear

Build 26.0.9776

Document

All documents the user has access to in the workspace.

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, <, <=, >, >=
title=, !=, IN, NOT IN, LIKE, CONTAINS
creatorId=, !=, IN, NOT IN
ownerId=, !=, IN, NOT IN, IS, IS NOT
projectId=, !=, IN, NOT IN
initiativeId=, !=, IN, NOT IN
teamId=, !=, IN, NOT IN, IS, IS NOT
issueId=, !=, IN, NOT IN
releaseId=, !=, IN, NOT IN
cycleId=, !=, IN, NOT IN
slugId=, !=, IN, NOT IN, LIKE, CONTAINS

For example, the following queries are processed server-side:

SELECT * FROM Document LIMIT 1
SELECT * FROM Document WHERE createdAt = '2026-01-01T00:00:00Z' LIMIT 1

INSERT

To insert a Document record:
INSERT INTO Document (title, teamId) VALUES ('sample', '921cb6bf-d5b6-44bb-9c6b-217b97dd27a2')

UPDATE

To update a Document record:
UPDATE Document SET title = 'sample' WHERE id = '19c0fae0-06ec-488d-a068-ae926ac0ce13'

DELETE

To delete a Document record:
DELETE FROM Document WHERE id = '19c0fae0-06ec-488d-a068-ae926ac0ce13'

Columns

Name Type ReadOnly Description
id [KEY] String False

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.

title String False

The title of the document. An empty string indicates an untitled document.

summary String True

[Internal] A one-sentence AI-generated summary of the document content. Null if no summary has been generated.

icon String False

The icon of the document, either a decorative icon type or an emoji string. Null if no icon has been set.

color String False

The hex color of the document icon. Null if no custom color has been set.

creatorId String True

The user who created the document. Null if the creator's account has been deleted.

ownerId String False

The owner of the document. Null if no owner is assigned or the owner's account has been deleted.

updatedById String True

The user who last updated the document. Null if the user's account has been deleted.

projectId String False

The project that the document is associated with. Null if the document belongs to a different parent entity type.

initiativeId String False

The initiative that the document is associated with. Null if the document belongs to a different parent entity type.

teamId String False

[Internal] The team that the document is associated with. Null if the document belongs to a different parent entity type.

issueId String False

The issue that the document is associated with. Null if the document belongs to a different parent entity type.

releaseId String False

The release that the document is associated with. Null if the document belongs to a different parent entity type.

cycleId String False

[Internal] The cycle that the document is associated with. Null if the document belongs to a different parent entity type.

slugId String True

The document's unique URL slug, used to construct human-readable URLs.

hiddenAt Datetime False

The time at which the document was hidden from the default view. Null if the document has not been hidden.

trashed Bool False

A flag that indicates whether the document is in the trash bin. Trashed documents are archived and can be restored.

sortOrder Double False

The sort order of the document in its parent entity's resources list. This order is shared with other resource types such as external links.

content String False

The document's content in markdown format.

contentState String True

[Internal] The document's content as a base64-encoded Yjs state update.

documentContentId String True

The ID of the document content associated with the document.

url String True

The canonical url for the document.

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