Initiative
Returns all initiatives in the workspace, with optional filtering and sorting.
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, <, <=, >, >= |
| name | =, !=, IN, NOT IN, LIKE, CONTAINS |
| creatorId | =, !=, IN, NOT IN, IS, IS NOT |
| ownerId | =, !=, IN, NOT IN, IS, IS NOT |
| leadTeamId | =, !=, IN, NOT IN, IS, IS NOT |
| slugId | =, !=, IN, NOT IN, LIKE, CONTAINS |
| targetDate | =, !=, IN, NOT IN, IS, IS NOT, <, <=, >, >= |
| status | =, !=, IN, NOT IN, LIKE, CONTAINS |
| health | =, !=, IN, NOT IN, LIKE, CONTAINS |
| 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, <, <=, >, >= |
For example, the following queries are processed server-side:
SELECT * FROM Initiative LIMIT 1
SELECT * FROM Initiative WHERE priority = 1 LIMIT 1
INSERT
To insert an Initiative record:INSERT INTO Initiative (name, description, ownerId) VALUES ('sample', 'sample', 'cfa5f5f6-bcd8-4a1e-9844-5186f9af10e3')
UPDATE
To update an Initiative record:UPDATE Initiative SET updateReminderFrequencyInWeeks = 1 WHERE id = '0617da23-e55d-4eeb-9eec-a02c812ddd8e'
DELETE
To delete an Initiative record:DELETE FROM Initiative WHERE id = '0617da23-e55d-4eeb-9eec-a02c812ddd8e'
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 initiative. |
| description | String | False |
The description of the initiative. |
| creatorId | String | True |
The user who created the initiative. |
| ownerId | String | False |
The user who owns the initiative. The owner is typically responsible for posting status updates and driving the initiative to completion. Null if no owner is assigned. |
| leadTeamId | String | False |
The team that leads the initiative. Null if no lead team is assigned. |
| slugId | String | True |
The initiative's unique URL slug, used to construct human-readable URLs. |
| sortOrder | Double | False |
The sort order of the initiative within the workspace. |
| color | String | False |
The initiative's color. |
| icon | String | False |
The icon of the initiative. Can be an emoji or a decorative icon type. |
| trashed | Bool | False |
A flag that indicates whether the initiative is in the trash bin. |
| targetDate | Date | False |
The estimated completion date of the initiative. Null if no target date is set. |
| targetDateResolution | String | False |
The resolution of the initiative's estimated completion date, indicating whether it refers to a specific day, week, month, quarter, or year. |
| status | String | False |
The lifecycle status of the initiative. One of Proposed, Planned, Active, Completed, Canceled. |
| lastUpdateId | String | True |
The most recent status update posted for this initiative. Null if no updates have been posted. |
| health | String | True |
The overall health of the initiative, derived from the most recent initiative update. Possible values are onTrack, atRisk, or offTrack. Null if no health has been reported. |
| healthUpdatedAt | Datetime | True |
The time at which the initiative health was last updated, typically when a new initiative update is posted. Null if health has never been set. |
| startedAt | Datetime | True |
The time at which the initiative was moved into Active status. Null if the initiative has not been activated. |
| completedAt | Datetime | True |
The time at which the initiative was moved into Completed status. Null if the initiative has not been completed. |
| canceledAt | Datetime | True |
[Internal] The time at which the initiative was moved into Canceled status. Null if the initiative has not been canceled. |
| labelIds | String | False |
The IDs of the initiative labels associated with this initiative. Returned as a JSON array of String values; accepts a JSON array or a comma-separated list when written. |
| priority | Int | False |
The priority of the initiative. 0 = No priority, 1 = Urgent, 2 = High, 3 = Medium, 4 = Low. |
| prioritySortOrder | Double | False |
The sort order of the initiative within the workspace when ordered by priority. |
| url | String | True |
Initiative URL. |
| visibility | String | True |
The visibility of the initiative, derived from its lead team. Public when no lead team is assigned. |
| identifier | String | True |
[Internal] The human-readable identifier of the initiative. Returns the custom identifier override when set, otherwise the workspace default `prefix-number`. Null for legacy initiatives that have not been backfilled and while initiative identifiers are not enabled for the workspace. |
| parentInitiativeId | String | True |
Parent initiative associated with the initiative. |
| content | String | False |
The initiative's content in markdown format. |