阅读进度
自动汇总所有资料摘要(
type: source)的阅读状态。由 Wiki 目录 维护,数据来自各 source 页 frontmatter 的read/read_date字段,无需手工维护列表。标记方式:对某份资料说”标记为已读”,LLM 会在其 frontmatter 写入
read: true+read_date。
统计概览
TABLE WITHOUT ID choice(read = true, "✅ 已读", "⬜ 未读") AS "状态", length(rows) AS "数量"
FROM "wiki"
WHERE type = "source"
GROUP BY choice(read = true, "✅ 已读", "⬜ 未读")
SORT 状态 ASC✅ 已读
TABLE WITHOUT ID file.link AS "资料", read_date AS "读完日期", media AS "类型", confidence AS "置信度"
FROM "wiki"
WHERE type = "source" AND read = true
SORT read_date DESC⬜ 未读
TABLE WITHOUT ID file.link AS "资料", media AS "类型", created AS "创建日期", confidence AS "置信度"
FROM "wiki"
WHERE type = "source" AND (read != true)
SORT created DESC