阅读进度

自动汇总所有资料摘要(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

相关