🏠 主仪表板

🔄 刷新方式: 打开数据库文件后返回此页面

📊 今日概览

📚 今日阅读活动

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, "![](" + 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插件。如需编辑数据,请访问对应的数据库文件。