ProjectMilestone
Returns all project milestones in the workspace, with optional filtering.
Table-Specific Information
SELECT
The add-in 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 add-in.| Column | Supported Operators |
| id | =, !=, IN, NOT IN |
| createdAt | =, !=, IN, NOT IN, <, <=, >, >= |
| updatedAt | =, !=, IN, NOT IN, <, <=, >, >= |
| name | =, !=, IN, NOT IN, IS, IS NOT, LIKE, CONTAINS |
| targetDate | =, !=, IN, NOT IN, IS, IS NOT, <, <=, >, >= |
| projectId | =, !=, IN, NOT IN, IS, IS NOT |
For example, the following queries are processed server-side:
SELECT * FROM ProjectMilestone LIMIT 1
SELECT * FROM ProjectMilestone WHERE createdAt = '2026-01-01T00:00:00Z' LIMIT 1
INSERT
To insert a ProjectMilestone record:INSERT INTO ProjectMilestone (name, projectId, sortOrder) VALUES ('Alpha Release', '16015fc0-0aeb-4a05-9c8b-3451a0ee5e2a', 1)
UPDATE
To update a ProjectMilestone record:UPDATE ProjectMilestone SET description = 'First public alpha release.' WHERE id = '921cb6bf-d5b6-44bb-9c6b-217b97dd27a2'
DELETE
To delete a ProjectMilestone record:DELETE FROM ProjectMilestone WHERE id = '921cb6bf-d5b6-44bb-9c6b-217b97dd27a2'
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. |
| name | String | False |
The name of the project milestone. |
| targetDate | Date | False |
The planned completion date of the milestone. Null if no target date is set. |
| projectId | String | False |
The project that this milestone belongs to. |
| progressHistory | String | True |
[Internal] The progress history of the milestone, tracking issue completion over time. |
| currentProgress | String | True |
[Internal] The current progress of the milestone, broken down by issue status category. |
| sortOrder | Double | False |
The order of the milestone in relation to other milestones within a project. |
| description | String | False |
The project milestone's description in markdown format. |
| status | String | True |
The status of the project milestone. |
| progress | Double | True |
The progress % of the project milestone. |
| descriptionState | String | True |
[Internal] The project milestone's description as YJS state. |