Vorfaelle-Register

Zentrales Register aller Sicherheitsvorfaelle und Datenpannen. Automatisch aktualisiert via Dataview.

---

Alle Sicherheitsvorfaelle

TABLE
  title AS "Vorfall",
  schweregrad AS "Schweregrad",
  entdeckungsdatum AS "Datum",
  status AS "Status",
  choice(datenpanne = true, "Ja", "Nein") AS "Datenpanne"
FROM "ISMSI" OR "ISDS2"
WHERE type = "vorfall"
SORT entdeckungsdatum DESC

---

Datenpannen-Dashboard

TABLE
  title AS "Vorfall/Datenpanne",
  schweregrad AS "Schweregrad",
  entdeckungsdatum AS "Datum",
  status AS "Status"
FROM "ISMSI" OR "ISDS2"
WHERE type = "vorfall" AND datenpanne = true
SORT entdeckungsdatum DESC

---

Vorfaelle nach Schweregrad

TABLE WITHOUT ID
  schweregrad AS "Schweregrad",
  length(rows) AS "Anzahl",
  length(filter(rows, (r) => r.status = "offen")) AS "Davon offen"
FROM "ISMSI" OR "ISDS2"
WHERE type = "vorfall"
GROUP BY schweregrad
SORT schweregrad DESC

---

Änderungshistorie

Datum	Autor	Änderung
2026-02-15	Visitrans	Execute SPEC-03: Plugins, templates, dashboards, placeholder replacement