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 |