Task Queries

these can get complex, I want to add a recursive example eventually, but I'm too lazy for now

---

All Undone or Pending Tasks in files in a directory with a category

SELECT * FROM tasks t
JOIN docs d ON d.id = t.file_id
JOIN categories c ON d.id = c.file_id
WHERE d.path LIKE '%/projects/%'
AND c.name = 'neorg'
AND (t.status = 'Undone' OR t.status = 'Pending')

Example output:

- (-) Make sure that the plugin actually works {:$/projects/neorg-query:# Make sure that the plugin actually works}[]
-- ( |# C) Priorities {:$/projects/neorg-query:# Priorities}[]
-- ( |# C) Some tasks that have the same text fail {:$/projects/neorg-query:# Some tasks that have the same text fail}[]
-- ( ) start dates and due dates {:$/projects/neorg-query:# start dates and due dates}[]
- ( |@ Tuesday 21 January 2025) Release the task update {:$/projects/neorg-query:# Release the task update}[]