InitiativeUpdate
Returns all initiative status updates in the workspace, with optional filtering.
Table-Specific Information
SELECT
The connector 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 connector.| Column | Supported Operators |
| id | =, !=, IN, NOT IN |
| createdAt | =, !=, IN, NOT IN, <, <=, >, >= |
| updatedAt | =, !=, IN, NOT IN, <, <=, >, >= |
| initiativeId | =, !=, IN, NOT IN |
| userId | =, !=, IN, NOT IN |
For example, the following queries are processed server-side:
SELECT * FROM InitiativeUpdate LIMIT 1
SELECT * FROM InitiativeUpdate WHERE createdAt = '2026-01-01T00:00:00Z' LIMIT 1
INSERT
To insert an InitiativeUpdate record:INSERT INTO InitiativeUpdate (initiativeId, body) VALUES ('0617da23-e55d-4eeb-9eec-a02c812ddd8e', 'sample')
UPDATE
To update an InitiativeUpdate record:UPDATE InitiativeUpdate SET body = 'sample' 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. |
| initiativeId | String | False |
The initiative that this status update was posted to. |
| userId | String | True |
The user who wrote the update. |
| health | String | False |
The health of the initiative at the time this update was posted. Possible values are onTrack, atRisk, or offTrack. |
| infoSnapshot | String | True |
[Internal] A snapshot of initiative properties at the time the update was posted, including project statuses, sub-initiative health, and target dates. 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. Only used for legacy updates. Not settable in the UI. |
| url | String | True |
The URL to the initiative update. |
| isStale | Bool | True |
Whether the initiative 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 initiative update. |