-- Fetch all the Issues belonging to the Linear
-- account of a particular user.
SELECT *
FROM fiber.linear_issue
WHERE account_id = '{user.linear_id}'
-- Fetch all the Issues belonging to the Linear
-- account of a particular user.
SELECT *
FROM fiber.linear_issue
WHERE account_id = '{user.linear_id}'
Code
CREATE TABLE fiber.linear_issue (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
account_id TEXT,
id TEXT,
title TEXT,
description TEXT,
state TEXT,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
due_date TIMESTAMP WITH TIME ZONE,
priority DOUBLE PRECISION,
assignee_id TEXT,
project_id TEXT,
team_id TEXT
)
CREATE TABLE fiber.linear_issue (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
account_id TEXT,
id TEXT,
title TEXT,
description TEXT,
state TEXT,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
due_date TIMESTAMP WITH TIME ZONE,
priority DOUBLE PRECISION,
assignee_id TEXT,
project_id TEXT,
team_id TEXT
)
Model definition