ProjectStatus

Returns all project statuses in the workspace.

Table-Specific Information

Retrieve Linear ProjectStatus records:

SELECT * FROM ProjectStatus LIMIT 1

To insert a ProjectStatus record:

INSERT INTO ProjectStatus (name, color, position, type) VALUES ('sample', '#5e6ad2', 1, 'backlog')

To update a ProjectStatus record:

UPDATE ProjectStatus SET name = 'sample' WHERE id = 'f325215e-9ec8-4a0d-87f1-2499ce3c2f0c'


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 status.
color	String	False	The color of the status as a HEX string, used for display in the UI.
description	String	False	Description of the status.
position	Double	False	The position of the status within its type group in the workspace's project flow. Used for ordering statuses of the same type.
type	String	False	The category type of the project status (e.g., backlog, planned, started, paused, completed, canceled). Determines the status's behavior and position in the project lifecycle.
indefinite	Bool	False	Whether a project can remain in this status indefinitely. When false, projects in this status may trigger reminders or auto-archiving after a period of inactivity.
teamId	String	False	[Internal] The team that the status is scoped to. If null, the status is a workspace-level status.
inheritedFromId	String	True	[Internal] The original workspace or parent-team status that this status was inherited from. Null if the status is not inherited.