in-progress
Todo List
管理你的任务清单。共 3 个任务。 筛选出 0 个
in-progress
in-progress
没有匹配筛选条件的任务
我的查询视图 (From Markdown)
任务清单
高优先级任务
显示所有高优先级的待办任务
| 标题 | DATE | CATEGORY |
|---|---|---|
| 2026前的待办 | 2025/12/10 | 开发 |
| 完成Qlog项目开发 | 2025/12/9 | qlog |
查看查询语句
TABLE date, category FROM "todo" WHERE priority = "high"进行中的任务
显示当前正在进行的任务
| 任务 | 优先级 | 进度 | 开始日期 |
|---|---|---|---|
| demo | medium | 2025/12/10 | |
| 2026前的待办 | high | 2025/12/10 | |
| 完成Qlog项目开发 | high | 2025/12/9 |
查看查询语句
TABLE WITHOUT ID
file.link AS "任务",
priority AS "优先级",
progress AS "进度",
date AS "开始日期"
FROM "todo"
WHERE status = "in-progress"
SORT priority DESC, date DESC即将到期的任务
显示未来7天内到期的任务
| 任务 | 状态 | 优先级 | 截止日期 |
|---|---|---|---|
| 暂无数据 | |||
查看查询语句
TABLE WITHOUT ID
file.link AS "任务",
status AS "状态",
priority AS "优先级",
dueDate AS "截止日期"
FROM "todo"
WHERE dueDate >= date(today) AND dueDate <= date(today) + dur(7 days) AND status != "done"
SORT dueDate ASC最近完成的任务
显示最近完成的5个任务
| 任务 | 优先级 | 类别 | 完成日期 |
|---|---|---|---|
| 暂无数据 | |||
查看查询语句
TABLE WITHOUT ID
file.link AS "任务",
priority AS "优先级",
category AS "类别",
date AS "完成日期"
FROM "todo"
WHERE status = "done"
SORT date DESC
LIMIT 5任务统计
按类别统计任务
统计不同类别的任务数量
| 类别 | 任务数 | LENGTH(FILTER(ROWS | 已完成 | LENGTH(FILTER(ROWS | 进行中 | LENGTH(FILTER(ROWS | 待办 |
|---|---|---|---|---|---|---|---|
| 开发 | 1 | 1 | - | 1 | - | 1 | - |
| qlog | 1 | 1 | - | 1 | - | 1 | - |
查看查询语句
TABLE WITHOUT ID
category AS "类别",
length(rows) AS "任务数",
length(filter(rows, (r) => r.status = "done")) AS "已完成",
length(filter(rows, (r) => r.status = "in-progress")) AS "进行中",
length(filter(rows, (r) => r.status = "todo")) AS "待办"
FROM "todo"
WHERE category != null
GROUP BY category
SORT length(rows) DESC按优先级统计任务
统计不同优先级的任务数量
| 优先级 | 总数 | LENGTH(FILTER(ROWS | 已完成 | LENGTH(FILTER(ROWS | 未完成 |
|---|---|---|---|---|---|
| high | 2 | 2 | - | 2 | - |
| medium | 1 | 1 | - | 1 | - |
查看查询语句
TABLE WITHOUT ID
priority AS "优先级",
length(rows) AS "总数",
length(filter(rows, (r) => r.status = "done")) AS "已完成",
length(filter(rows, (r) => r.status != "done")) AS "未完成"
FROM "todo"
WHERE priority != null
GROUP BY priority
SORT priority ASC