37 lines
817 B
SQL
37 lines
817 B
SQL
SELECT 'dynamic' AS component, sqlpage.run_sql('shell.sql') AS properties;
|
|
|
|
SELECT 'card' AS component,
|
|
'Applications' AS title;
|
|
|
|
SELECT name AS title,
|
|
coalesce(severity_color,'green' ) AS background_color,
|
|
incident_title as description
|
|
|
|
FROM application_status;
|
|
|
|
SELECT 'divider' AS component,
|
|
'incidents' AS contents
|
|
;
|
|
|
|
select
|
|
'timeline' as component;
|
|
select
|
|
i.title as title,
|
|
'incident.sql?id=' || i.id AS link,
|
|
CASE
|
|
WHEN i.status = 'CLOSED' THEN 'resolved'
|
|
ELSE ''
|
|
END
|
|
AS class,
|
|
i.date_time as date,
|
|
i.description as description,
|
|
s.color AS color,
|
|
CASE
|
|
WHEN i.status = 'CLOSED' THEN 'alert-triangle-off'
|
|
ELSE 'alert-triangle'
|
|
END
|
|
AS icon
|
|
from incident i
|
|
JOIN severity s on i.severity = s.id
|
|
order by i.date_time desc
|
|
; |