ProjectUpdate
Returns all project status updates in the workspace, with optional filtering.
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.| Column | Supported Operators |
| id | =, !=, IN, NOT IN |
| createdAt | =, !=, IN, NOT IN, <, <=, >, >= |
| updatedAt | =, !=, IN, NOT IN, <, <=, >, >= |
| projectId | =, !=, IN, NOT IN |
| userId | =, !=, IN, NOT IN |
For example, the following queries are processed server-side:
SELECT * FROM ProjectUpdate LIMIT 1
SELECT * FROM ProjectUpdate WHERE createdAt = '2026-01-01T00:00:00Z' LIMIT 1
INSERT
To insert a ProjectUpdate record:INSERT INTO ProjectUpdate (projectId, health, body, bodyData, isDiffHidden) VALUES ('16015fc0-0aeb-4a05-9c8b-3451a0ee5e2a', 'onTrack', 'Project is progressing well.', '{}', false)
UPDATE
To update a ProjectUpdate record:UPDATE ProjectUpdate SET body = 'Project is slightly delayed due to scope change.' WHERE id = '92f7a1e0-056b-44b4-80d9-43e0b0f3dda6'
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. |
| body | String | False |
The update content in markdown format. |
| editedAt | Datetime | True |
The time the update was edited. |
| reactionData | String | True |
Emoji reaction summary, grouped by emoji type. |
| bodyData | String | False |
[Internal] The content of the update as a Prosemirror document. |
| slugId | String | True |
The update's unique URL slug. |
| shortSummary | String | True |
A short AI-generated summary of the project update. Null if no short summary is available. |
| projectId | String | False |
The project that this status update was posted to. |
| health | String | False |
The health of the project at the time this update was posted. Possible values are onTrack, atRisk, or offTrack. |
| userId | String | True |
The user who wrote the update. |
| infoSnapshot | String | True |
[Internal] A snapshot of project properties at the time the update was posted, including team, milestone, and issue statistics. Used to compute diffs between consecutive updates. |
| isDiffHidden | Bool | False |
Whether the diff between this update and the previous one should be hidden in the UI. |
| url | String | True |
The URL to the project update. |
| isStale | Bool | True |
Whether the project update is stale. |
| diff | String | True |
The diff between the current update and the previous one. |
| diffMarkdown | String | True |
The diff between the current update and the previous one, formatted as markdown. |
| commentCount | Int | True |
Number of comments associated with the project update. |