Table: linear_issue_label - Query Linear Issue Labels using SQL
Linear Issue Labels are a feature within Linear, a project management and issue tracking tool. They allow for categorization and organization of issues, enhancing the ability to manage and track tasks within a project. Labels can be customized with unique names and colors, providing visual cues and facilitating issue sorting and filtering.
Table Usage Guide
The linear_issue_label
table provides insights into issue labels within Linear's issue tracking system. As a project manager or developer, explore label-specific details through this table, including label names, colors, and associated issues. Utilize it to uncover information about label usage, such as frequency of use, the distribution of labels across issues, and the effectiveness of current label organization strategies.
Examples
Basic info
Explore the general details of issue labels in a project management tool. This is useful to understand the timeline and categorization of issues for better project tracking and management.
select id, title, created_at, color, updated_atfrom linear_issue_label;
select id, title, created_at, color, updated_atfrom linear_issue_label;
List labels which are not associated with any team
Explore which issue labels are not linked to a team. This can be useful for identifying potential areas of miscommunication or disorganization within your project management system.
select id, title, created_at, color, updated_atfrom linear_issue_labelwhere team is null;
select id, title, created_at, color, updated_atfrom linear_issue_labelwhere team is null;
List all labels for each issue
Discover the segments that have been categorized under each issue. This is useful for understanding how issues are labelled and organized, which can aid in issue tracking and management.
select i.title as issue_title, l.title as label_tilefrom linear_issue as i, linear_issue_label as l, jsonb_array_elements(issue_ids) as idswhere i.id = ids ->> 'id';
select i.title as issue_title, l.title as label_tilefrom linear_issue as i, linear_issue_label as l, json_each(issue_ids) as idswhere i.id = json_extract(ids.value, '$.id');
Show archived labels
Uncover the details of archived labels within your project management tool. This query is useful in identifying labels that are no longer in active use, helping to streamline and organize your project management process.
select id, title, created_at, color, updated_atfrom linear_issue_labelwhere archived_at is not null;
select id, title, created_at, color, updated_atfrom linear_issue_labelwhere archived_at is not null;
List labels created by admin
Explore which issue labels have been created by an admin. This can be useful for understanding the administrative actions and categorisations within your project.
select id, title, created_at, color, updated_atfrom linear_issue_labelwhere creator ->> 'admin' = 'true';
select id, title, created_at, color, updated_atfrom linear_issue_labelwhere json_extract(creator, '$.admin') = 'true';
List child labels of a particular label
Explore which child labels belong to a specific parent label, allowing you to understand the organization and categorization of issues within your project.
select id, title, created_at, color, updated_atfrom linear_issue_labelwhere parent ->> 'name' = 'issueLabel';
select id, title, created_at, color, updated_atfrom linear_issue_labelwhere json_extract(parent, '$.name') = 'issueLabel';
Schema for linear_issue_label
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form. | |
archived_at | timestamp with time zone | The time at which the entity was archived. Null if the entity has not been archived. | |
color | text | The label's color as a HEX string. | |
created_at | timestamp with time zone | The time at which the entity was created. | |
creator | jsonb | The user who created the label. | |
description | text | The label's description. | |
id | text | = | The unique identifier of the entity. |
issue_ids | jsonb | The issue ids associated with the label. | |
name | text | = | The label's name. |
organization | jsonb | The organization associated with the label. | |
organization_id | text | =, !=, ~~, ~~*, !~~, !~~* | Unique identifier for the organization. |
parent | jsonb | The parent label. | |
sp_connection_name | text | =, !=, ~~, ~~*, !~~, !~~* | Steampipe connection name. |
sp_ctx | jsonb | Steampipe context in JSON form. | |
team | jsonb | The team that the label is associated with. If null, the label is associated with the global workspace. | |
title | text | The issue label's title. | |
updated_at | timestamp with time zone | The last time at which the entity was meaningfully updated, i.e. for all changes of syncable properties except those for which updates should not produce an update to updatedAt (see skipUpdatedAtKeys). This is the same as the creation time if the entity hasn't been updated after creation. |
Export
This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.
You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh
script:
/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- linear
You can pass the configuration to the command with the --config
argument:
steampipe_export_linear --config '<your_config>' linear_issue_label