Episode 2 of Rozz Queries is about incident follow-ups: the action items that get written down after an incident and then never done.
Watch it on X or Instagram. TikTok is still under review, and YouTube will follow once the @wearthecrash sign-in is sorted.
The query on Rozz's monitor is number 9 in our free Dataview pack, "Incident follow-ups still open":
TASK FROM "Incidents" WHERE !completed AND status != "-" AND text != "" GROUP BY file.link It shows every unchecked follow-up task in your incident notes, grouped by incident. It doesn't need any special fields, only checkboxes in the notes in your Incidents folder. Like the other task queries in the pack, it leaves out cancelled [-] tasks and empty checkboxes.
That's the whole idea. If the follow-ups live as checkboxes in the incident note, one query can show you which incidents still have open work, and you'll see it before the same bug shows up again.
If your incident notes live somewhere else, change the folder name after FROM.
Episode 3, the finale, is about "we'll fix it later".
Dataview Starter Queries is free on Gumroad (pay what you want, $0 is fine): https://subengel.gumroad.com/l/dzanl
More of what we make: https://engelailabs.com
