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

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