steampipe plugin install linear

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_at
from
linear_issue_label;
select
id,
title,
created_at,
color,
updated_at
from
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_at
from
linear_issue_label
where
team is null;
select
id,
title,
created_at,
color,
updated_at
from
linear_issue_label
where
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_tile
from
linear_issue as i,
linear_issue_label as l,
jsonb_array_elements(issue_ids) as ids
where
i.id = ids ->> 'id';
select
i.title as issue_title,
l.title as label_tile
from
linear_issue as i,
linear_issue_label as l,
json_each(issue_ids) as ids
where
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_at
from
linear_issue_label
where
archived_at is not null;
select
id,
title,
created_at,
color,
updated_at
from
linear_issue_label
where
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_at
from
linear_issue_label
where
creator ->> 'admin' = 'true';
select
id,
title,
created_at,
color,
updated_at
from
linear_issue_label
where
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_at
from
linear_issue_label
where
parent ->> 'name' = 'issueLabel';
select
id,
title,
created_at,
color,
updated_at
from
linear_issue_label
where
json_extract(parent, '$.name') = 'issueLabel';

Schema for linear_issue_label

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
archived_attimestamp with time zoneThe time at which the entity was archived. Null if the entity has not been archived.
colortextThe label's color as a HEX string.
created_attimestamp with time zoneThe time at which the entity was created.
creatorjsonbThe user who created the label.
descriptiontextThe label's description.
idtext=The unique identifier of the entity.
issue_idsjsonbThe issue ids associated with the label.
nametext=The label's name.
organizationjsonbThe organization associated with the label.
organization_idtext=, !=, ~~, ~~*, !~~, !~~*Unique identifier for the organization.
parentjsonbThe parent label.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
teamjsonbThe team that the label is associated with. If null, the label is associated with the global workspace.
titletextThe issue label's title.
updated_attimestamp with time zoneThe 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