IssueLabel
All issue labels. Returns a paginated list of labels visible to the authenticated user, including both workspace-level and team-scoped labels.
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 | =, != |
| teamId | =, !=, IN, NOT IN, IS, IS NOT |
| creatorId | =, !=, IN, NOT IN, IS, IS NOT |
| parentId | =, !=, IN, NOT IN |
For example, the following queries are processed server-side:
SELECT * FROM IssueLabel LIMIT 1
SELECT * FROM IssueLabel WHERE isGroup = true LIMIT 1
INSERT
To insert an IssueLabel record:INSERT INTO IssueLabel (name, description, color) VALUES ('sample', 'sample', '#5e6ad2')
UPDATE
To update an IssueLabel record:UPDATE IssueLabel SET name = 'sample' WHERE id = '4591acc3-3632-4d99-8bb2-48552bc89649'
DELETE
To delete an IssueLabel record:DELETE FROM IssueLabel WHERE id = '4591acc3-3632-4d99-8bb2-48552bc89649'
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 |
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. |
| parentId | String | False |
The parent label. |
| inheritedFromId | String | True |
The original workspace or parent-team label that this label was inherited from. Null if the label is not inherited. |