WorkflowState
All issue workflow states (issue statuses). Returns a paginated list of workflow states visible to the authenticated user, across all teams they have access to.
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 |
| description | =, !=, IN, NOT IN, LIKE, CONTAINS |
| position | =, !=, IN, NOT IN, <, <=, >, >= |
| type | =, !=, IN, NOT IN, LIKE, CONTAINS |
| teamId | =, !=, IN, NOT IN |
For example, the following queries are processed server-side:
SELECT * FROM WorkflowState LIMIT 1
SELECT * FROM WorkflowState WHERE position = 1 LIMIT 1
INSERT
To insert a WorkflowState record:INSERT INTO WorkflowState (name, color, type, teamId) VALUES ('sample', '#5e6ad2', 'backlog', '921cb6bf-d5b6-44bb-9c6b-217b97dd27a2')
UPDATE
To update a WorkflowState record:UPDATE WorkflowState SET name = 'sample' WHERE id = 'e9e975c3-bc37-4fdc-a737-269866061c3e'
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 state's human-readable name (e.g., 'In Progress', 'Done', 'Backlog'). |
| color | String | False |
The state's UI color as a HEX string. |
| description | String | False |
Description of the state. |
| position | Double | False |
The position of the state in the team's workflow. States are displayed in ascending order of position within their type group. |
| type | String | False |
The type of the state. One of |
| teamId | String | False |
The team that this workflow state belongs to. Each team has its own set of workflow states. |
| inheritedFromId | String | True |
The parent team's workflow state that this state was inherited from. Null if the state is not inherited from a parent team. |