Project
Returns all projects in the workspace, with optional filtering and sorting.
Table-Specific Information
SELECT
The driver 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 driver.| Column | Supported Operators |
| id | =, !=, IN, NOT IN |
| createdAt | =, !=, IN, NOT IN, <, <=, >, >= |
| updatedAt | =, !=, IN, NOT IN, <, <=, >, >= |
| name | =, !=, IN, NOT IN, LIKE, CONTAINS |
| slugId | =, !=, IN, NOT IN, LIKE, CONTAINS |
| statusId | =, !=, IN, NOT IN |
| creatorId | =, !=, IN, NOT IN |
| leadId | =, !=, IN, NOT IN, IS, IS NOT |
| leadTeamId | =, !=, IN, NOT IN, IS, IS NOT |
| startDate | =, !=, IN, NOT IN, IS, IS NOT, <, <=, >, >= |
| targetDate | =, !=, IN, NOT IN, IS, IS NOT, <, <=, >, >= |
| startedAt | =, !=, IN, NOT IN, IS, IS NOT, <, <=, >, >= |
| completedAt | =, !=, IN, NOT IN, IS, IS NOT, <, <=, >, >= |
| canceledAt | =, !=, IN, NOT IN, IS, IS NOT, <, <=, >, >= |
| priority | =, !=, IN, NOT IN, IS, IS NOT, <, <=, >, >= |
| health | =, !=, IN, NOT IN, LIKE, CONTAINS |
For example, the following queries are processed server-side:
SELECT * FROM Project LIMIT 1
SELECT * FROM Project WHERE priority = 1 LIMIT 1
INSERT
To insert a Project record:INSERT INTO Project (name, description, color, priority, prioritySortOrder, sortOrder, frequencyResolution, statusId) VALUES ('Mobile App Redesign', 'Redesign the mobile app for better UX.', '#5e6ad2', 1, 1.0, 1.0, 'weekly', 'f325215e-9ec8-4a0d-87f1-2499ce3c2f0c')
UPDATE
To update a Project record:UPDATE Project SET name = 'Mobile App Redesign 2026' WHERE id = '16015fc0-0aeb-4a05-9c8b-3451a0ee5e2a'
DELETE
To delete a Project record:DELETE FROM Project WHERE id = '16015fc0-0aeb-4a05-9c8b-3451a0ee5e2a'
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. |
| updateReminderFrequencyInWeeks | Double | False |
The n-weekly frequency at which to prompt for updates. When not set, reminders are inherited from workspace. |
| updateReminderFrequency | Double | False |
The frequency at which to prompt for updates. When not set, reminders are inherited from workspace. |
| frequencyResolution | String | False |
The resolution of the reminder frequency. |
| updateRemindersDay | String | False |
The day at which to prompt for updates. |
| updateRemindersHour | Double | False |
The hour at which to prompt for updates. |
| name | String | False |
The name of the project. |
| description | String | False |
The short description of the project. |
| slugId | String | True |
The project's unique URL slug, used to construct human-readable URLs. |
| icon | String | False |
The icon of the project. Can be an emoji or a decorative icon type. |
| color | String | False |
The project's color as a HEX string. Used in the UI to visually identify the project. |
| statusId | String | False |
The current project status. Defines the project's position in its lifecycle (e.g., backlog, planned, started, paused, completed, canceled). |
| creatorId | String | True |
The user who created the project. |
| leadId | String | False |
The user who leads the project. The project lead is typically responsible for posting status updates and driving the project to completion. Null if no lead is assigned. |
| leadTeamId | String | False |
[Internal] The team that leads the project. Null if the viewer does not have access to the team. |
| projectUpdateRemindersPausedUntilAt | Datetime | False |
The time until which project update reminders are paused. When set, no update reminders will be sent for this project until this date passes. Null means reminders are active. |
| startDate | Date | False |
The estimated start date of the project. Null if no start date is set. |
| startDateResolution | String | False |
The resolution of the project's start date, indicating whether it refers to a specific month, quarter, half-year, or year. |
| targetDate | Date | False |
The estimated completion date of the project. Null if no target date is set. |
| targetDateResolution | String | False |
The resolution of the project's estimated completion date, indicating whether it refers to a specific month, quarter, half-year, or year. |
| startedAt | Datetime | True |
The time at which the project was moved into a started status. Null if the project has not been started. |
| completedAt | Datetime | False |
The time at which the project was moved into a completed status. Null if the project has not been completed. |
| canceledAt | Datetime | False |
The time at which the project was moved into a canceled status. Null if the project has not been canceled. |
| autoArchivedAt | Datetime | True |
The time at which the project was automatically archived by the auto-pruning process. Null if the project has not been auto-archived. |
| trashed | Bool | False |
A flag that indicates whether the project is in the trash bin. |
| sortOrder | Double | False |
The sort order for the project within the workspace. Used for manual ordering in list views. |
| prioritySortOrder | Double | False |
The sort order for the project within the workspace when ordered by priority. |
| convertedFromIssueId | String | False |
The issue that was converted into this project. Null if the project was not created from an issue. |
| priority | Int | False |
The priority of the project. 0 = No priority, 1 = Urgent, 2 = High, 3 = Medium, 4 = Low. |
| lastUpdateId | String | True |
The most recent status update posted for this project. Null if no updates have been posted. |
| health | String | True |
The overall health of the project, derived from the most recent project update. Possible values are onTrack, atRisk, or offTrack. Null if no health has been reported. |
| healthUpdatedAt | Datetime | True |
The time at which the project health was last updated, typically when a new project update is posted. Null if health has never been set. |
| issueCountHistory | String | True |
The total number of issues in the project at the end of each week since project creation. Each entry represents one week. 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 project at the end of each week since project creation. Each entry represents one week. Returned as a JSON array of Float values; accepts a JSON array or a comma-separated list when written. |
| scopeHistory | String | True |
The total scope (estimation points) of the project at the end of each week since project creation. Each entry represents one week. 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 at the end of each week since project creation. Each entry represents one week. 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 at the end of each week since project creation. Each entry represents one week. Returned as a JSON array of Float values; accepts a JSON array or a comma-separated list when written. |
| progressHistory | String | True |
[INTERNAL] The progress history of the project, tracking issue completion over time. |
| currentProgress | String | True |
[INTERNAL] The current progress of the project, broken down by issue status category. |
| labelIds | String | False |
The IDs of the project labels associated with this project. Returned as a JSON array of String values; accepts a JSON array or a comma-separated list when written. |
| favoriteId | String | True |
The user's favorite associated with this project. |
| url | String | True |
Project URL. |
| identifier | String | True |
[Internal] The human-readable identifier of the project. Returns the custom identifier override when set, otherwise the default `P-leadTeamKey-number`. Null for projects without a lead team, for legacy projects that have not been backfilled, and while project identifiers are not enabled for the workspace. |
| resourceCount | Int | True |
The number of resources associated with the project, including documents, external links, and attachments. |
| progress | Double | True |
The overall progress of the project. This is the (completed estimate points + 0.25 * in progress estimate points) / total estimate points. |
| scope | Double | True |
The overall scope (total estimate points) of the project. |
| slackChannelId | String | True |
The ID of the Slack channel connected to the project, if any. |
| microsoftTeamsChannelId | String | True |
The ID of the Microsoft Teams channel connected to the project, if any. |
| content | String | False |
The project's content in markdown format. |
| contentState | String | True |
[Internal] The project's content as YJS state. |
| priorityLabel | String | True |
The priority of the project as a label. |
| teamIds | String | False |
The identifiers of the teams this project is associated with. Accepts a comma-separated list or JSON array of String values. Used only when creating or updating a record; reads return NULL. |