# TASKS

## TODO:
${query[[
  from task = index.tag "page"
  where task.name.startsWith("99_ARCHIVES/TASKS/") and task.status == "todo" and task.type == "task" 
  order by task.name desc 
  limit 100
  select {
    TASK = "[[" .. task.ref .. "]]",
    STATUS = task.status,
    DATE = task.date,
    PROJECT = "[[" .. task.project .. "]]",
    ISSUE = "[[" .. task.issue .. "]]" or "",
    TITLE = task.title
  }
]]}

## DONE:
${query[[
  from task = index.tag "page"
  where task.name.startsWith("99_ARCHIVES/TASKS/") and task.status == "done" and task.type == "task" 
  order by task.name desc 
  limit 100
  select {
    TASK = "[[" .. task.ref .. "]]",
    STATUS = task.status,
    DATE = task.date,
    PROJECT = "[[" .. task.project .. "]]",
    ISSUE = "[[" .. task.issue .. "]]" or "",
    TITLE = task.title
  }
]]}