Zum Inhalt

Massnahmen-Register

Zentrales Register aller Massnahmen ueber alle 4 Spaces. Automatisch aktualisiert via Dataview.


Alle Massnahmen

TABLE
  title AS "Massnahme",
  management_system AS "Space",
  kategorie AS "Kategorie",
  verantwortlicher AS "Verantwortlich",
  frist AS "Frist",
  status AS "Status"
FROM "IMS" OR "ISMSI" OR "QMS" OR "ISDS2"
WHERE type = "massnahme"
SORT frist ASC

Ueberfaellige Massnahmen

TABLE
  title AS "Massnahme",
  management_system AS "Space",
  verantwortlicher AS "Verantwortlich",
  frist AS "Frist",
  dateformat(date(today) - frist, "d 'Tage'") AS "Ueberfaellig seit"
FROM "IMS" OR "ISMSI" OR "QMS" OR "ISDS2"
WHERE type = "massnahme"
  AND status != "abgeschlossen"
  AND frist < date(today)
SORT frist ASC

Massnahmen nach Space

TABLE WITHOUT ID
  management_system AS "Space",
  length(rows) AS "Gesamt",
  length(filter(rows, (r) => r.status = "offen")) AS "Offen",
  length(filter(rows, (r) => r.status = "in_bearbeitung")) AS "In Bearbeitung",
  length(filter(rows, (r) => r.status = "abgeschlossen")) AS "Abgeschlossen"
FROM "IMS" OR "ISMSI" OR "QMS" OR "ISDS2"
WHERE type = "massnahme"
GROUP BY management_system
SORT management_system ASC

Massnahmen nach Kategorie

TABLE WITHOUT ID
  kategorie AS "Kategorie",
  length(rows) AS "Anzahl",
  length(filter(rows, (r) => r.status = "offen")) AS "Davon offen"
FROM "IMS" OR "ISMSI" OR "QMS" OR "ISDS2"
WHERE type = "massnahme"
GROUP BY kategorie

Änderungshistorie

Datum Autor Änderung
2026-02-15 Visitrans SPEC-05: Operative Module — Template-Fixes, Testdaten, Validator, E2E validiert
2026-02-14 Visitrans Execute SPEC-01: Bulk-Export 646 Confluence pages to Obsidian vault