-- Fetch all the Alerts belonging to the Opsgenie
-- account of a particular user.
SELECT *
FROM fiber.opsgenie_alert
WHERE account_id = '{user.opsgenie_id}'
-- Fetch all the Alerts belonging to the Opsgenie
-- account of a particular user.
SELECT *
FROM fiber.opsgenie_alert
WHERE account_id = '{user.opsgenie_id}'
Code
CREATE TABLE fiber.opsgenie_alert (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
account_id TEXT,
tiny_id TEXT,
alias TEXT,
message TEXT,
status TEXT,
acknowledged BOOLEAN,
is_seen BOOLEAN,
tags TEXT[],
snoozed BOOLEAN,
snoozed_until TEXT,
count INT,
last_occurred_at TEXT,
created_at TEXT,
updated_at TEXT,
source TEXT,
owner TEXT,
priority TEXT,
responders JSONB,
integration JSONB,
report JSONB,
actions TEXT[],
entity TEXT,
description TEXT,
details JSONB
)
CREATE TABLE fiber.opsgenie_alert (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
account_id TEXT,
tiny_id TEXT,
alias TEXT,
message TEXT,
status TEXT,
acknowledged BOOLEAN,
is_seen BOOLEAN,
tags TEXT[],
snoozed BOOLEAN,
snoozed_until TEXT,
count INT,
last_occurred_at TEXT,
created_at TEXT,
updated_at TEXT,
source TEXT,
owner TEXT,
priority TEXT,
responders JSONB,
integration JSONB,
report JSONB,
actions TEXT[],
entity TEXT,
description TEXT,
details JSONB
)
Model definition
