We'll fix it later: a short about tech debt you keep promising to get to, and a tiny register for it in Obsidian

The last episode of Rozz Queries is about "we'll fix it later". It's easy to say and easy to forget what "it" was.

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 10 in our free Dataview pack, the tech debt register:

TABLE area AS "Area", priority AS "Priority", estimate_hours AS "Est. h", created AS "Created"
FROM "Debt"
WHERE type = "debt" AND status != "resolved"
SORT priority ASC, created ASC

Each debt item is one small note in a Debt folder with a few frontmatter fields: type: debt, area, priority, status (open, in-progress or resolved), created as an ISO date, and an optional estimate_hours. The query shows everything that isn't resolved, highest priority first, then oldest first.

One thing to get right: use a number for priority, where 1 means fix now and 4 means someday. If you write high or low, Dataview sorts them as text, alphabetically, and the order comes out wrong.

That's the end of the set. All ten queries are in one note you can drop into your vault, and each one says what it shows and which fields it expects. You need Obsidian and the free Dataview plugin.

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