🏠 主仪表板
🔄 刷新方式: 打开数据库文件后返回此页面
📊 今日概览
📚 今日阅读活动
filters:
and:
- or:
- file.hasTag("书籍")
- file.folder.startswith("1-Source/12-Book")
- readingDate == date(today)
formulas:
book_count: length(title)
display_title: if(title, "📖 " + title, "暂无阅读")
properties:
formula.display_title:
displayName: 今日阅读
readingStatus:
displayName: 状态
views:
- type: table
name: 今日阅读
order:
- title
sort:
- column: title
direction: ASC📋 今日新增项目
filters:
and:
- file.folder.startswith("0-Inbox")
- created == date(today)
- status != "已归档"
formulas:
created_display: created.format("HH:mm")
priority_weight: if(priority == "高", 1, if(priority == "中", 2, 3))
properties:
title:
displayName: 项目标题
formula.created_display:
displayName: 创建时间
priority:
displayName: 优先级
status:
displayName: 状态
views:
- type: table
name: 今日新增
order:
- formula.priority_weight
- formula.created_display
sort:
- property: formula.created_display
direction: ASC
📚 最近阅读(7天内)
filters:
and:
- or:
- file.hasTag("书籍")
- file.folder.startswith("1-Source/12-Book")
- readingDate >= date(today) - 7
formulas:
days_ago: date(today) - readingDate
date_display: readingDate.format("MM-dd")
cover_display: if(cover, "", "📚")
properties:
formula.cover_display:
displayName: 封面
title:
displayName: 书名
author:
displayName: 作者
readingStatus:
displayName: 状态
formula.date_display:
displayName: 阅读日期
formula.days_ago:
displayName: 天数前
views:
- type: table
name: 最近阅读
order:
- readingDate
- title
sort:
- column: readingDate
direction: DESC
- column: title
direction: ASC📋 最近添加项目(7天内)
filters:
and:
- file.folder.startswith("0-Inbox")
- created >= date(today) - 7
- status != "已归档"
formulas:
days_ago: date(today) - created
created_display: created.format("MM-dd HH:mm")
status_priority: if(status == "进行中", 1, if(status == "待处理", 2, if(status == "已完成", 3, 4)))
properties:
title:
displayName: 项目标题
status:
displayName: 状态
category:
displayName: 分类
formula.created_display:
displayName: 创建时间
formula.days_ago:
displayName: 天数前
views:
- type: table
name: 最近项目
order:
- formula.status_priority
- created
sort:
- column: formula.status_priority
direction: ASC
- column: created
direction: DESC🎯 快速操作
📈 本周统计
书籍阅读统计
filters:
and:
- or:
- file.hasTag("书籍")
- file.folder.startswith("1-Source/12-Book")
- readingDate >= date(today) - 7
formulas:
week_start: date(today) - date(today).weekday()
is_this_week: readingDate >= week_start
properties:
title:
displayName: 书名
readingStatus:
displayName: 状态
readingDate:
displayName: 阅读日期
formula.is_this_week:
displayName: 本周
views:
- type: table
name: 本周阅读
order:
- readingDate
- title
sort:
- column: readingDate
direction: DESC
- column: title
direction: ASC项目完成统计
filters:
and:
- file.folder.startswith("0-Inbox")
- created >= date(today) - 7
- or:
- status == "已完成"
- status == "进行中"
formulas:
completed_status: if(status == "已完成", "✅", "🔄")
week_start: date(today) - date(today).weekday()
created_display: created.format("MM-dd")
properties:
title:
displayName: 项目名称
formula.completed_status:
displayName: 状态
category:
displayName: 分类
formula.created_display:
displayName: 创建日期
views:
- type: table
name: 本周项目
order:
- status
- created
sort:
- column: status
direction: ASC
- column: created
direction: DESC🏠 主页 | 最后更新:= dateformat(date(now()), "yyyy-MM-dd HH:mm")
💡 提示:此页面使用Obsidian Base插件。如需编辑数据,请访问对应的数据库文件。