DEV Community

Sub Engel
Sub Engel

Posted on

Didn't we already fix this? A short about incident follow-ups nobody did, and the query that keeps them in view

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
Enter fullscreen mode Exit fullscreen mode

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

Top comments (0)