工作台

快捷操作

创建今日笔记：button-work-daily 创建任务笔记：button-work-task

今日待办

not done
(scheduled today) OR (due today)
exclude sub-items

本周任务

not done
(due this week) OR (scheduled this week)
exclude sub-items
sort by priority

本周已完成

done this week

任务全景

TABLE WITHOUT ID
  file.link AS "任务",
  choice(
    length(file.tasks) = 0, "—",
    length(filter(file.tasks, (t) => t.completed)) + "/" + length(file.tasks)
  ) AS "进度",
  file.frontmatter.ForcePower AS "工作量",
  join(file.frontmatter.需求人, ", ") AS "需求人",
  join(file.frontmatter.tags, ", ") AS "标签"
FROM "CYG-Works/需求任务-Tasks"
WHERE file.frontmatter.tags
SORT choice(
  length(file.tasks) = 0, 2,
  choice(
    length(filter(file.tasks, (t) => !t.completed)) > 0, 0,
    1
  )
) ASC, file.mday DESC