ProjectLabel
Returns all project labels 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, <, <=, >, >= |
| name | =, !=, IN, NOT IN, LIKE, CONTAINS |
| isGroup | =, != |
| creatorId | =, !=, IN, NOT IN, IS, IS NOT |
| parentId | =, !=, IN, NOT IN |
For example, the following queries are processed server-side:
SELECT * FROM ProjectLabel LIMIT 1
SELECT * FROM ProjectLabel WHERE isGroup = true LIMIT 1
INSERT
To insert a ProjectLabel record:INSERT INTO ProjectLabel (name, description, color) VALUES ('sample', 'sample', '#5e6ad2')
UPDATE
To update a ProjectLabel record:UPDATE ProjectLabel SET name = 'sample' WHERE id = '28920324-ec4a-4c91-a057-589ff4bc6f07'
DELETE
To delete a ProjectLabel record:DELETE FROM ProjectLabel WHERE id = '28920324-ec4a-4c91-a057-589ff4bc6f07'
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 label's name. |
| description | String | False |
The label's description. |
| color | String | False |
The label's color as a HEX string (e.g., '#EB5757'). Used for visual identification of the label in the UI. |
| isGroup | Bool | False |
Whether the label is a group. When true, this label acts as a container for child labels and cannot be directly applied to issues or projects. When false, the label can be directly applied. |
| lastAppliedAt | Datetime | True |
The date when the label was last applied to an issue, project, or initiative. Null if the label has never been applied. |
| retiredAt | Datetime | False |
[Internal] When the label was retired. |
| teamId | String | False |
[Internal] The team that the label is scoped to. If null, the label is a workspace-level label available to all teams in the workspace. |
| creatorId | String | True |
The user who created the label. |
| retiredById | String | True |
The user who retired the label. Retired labels cannot be applied to new projects but remain on existing ones. Null if the label is active. |
| parentId | String | False |
The parent label group. If set, this label is a child within a group. Only one child label from each group can be applied to a project at a time. |
| inheritedFromId | String | True |
[Internal] The original workspace or parent-team label that this label was inherited from. Null if the label is not inherited. |