Books Database

书籍数据库

filters:
  or:
    - file.hasTag("书籍")
    - file.folder.startswith("1-Source/12-Book")
formulas:
  cover_display: if(cover, "![](" + cover + ")", "📚")
  status_display: if(readingStatus, readingStatus, "未开始")
  date_display: if(readingDate, readingDate.format("yyyy-MM-dd"), "")
properties:
  formula.cover_display:
    displayName: 封面
  title:
    displayName: 书名
  author:
    displayName: 作者
  formula.status_display:
    displayName: 状态
  formula.date_display:
    displayName: 阅读日期
  readingTime:
    displayName: 阅读时长
  rating:
    displayName: 评分
  tags:
    displayName: 标签
  category:
    displayName: 分类
views:
  - type: table
    name: 全部书籍
    filters:
      or:
        - file.hasTag("书籍")
        - file.folder.startswith("1-Source/12-Book")
    order:
      - formula.status_display
      - formula.date_display
      - title
    sort:
      - column: formula.status_display
        direction: ASC
      - column: formula.date_display
        direction: DESC
      - column: title
        direction: ASC
  - type: table
    name: 在读书籍
    filters:
      and:
        - readingStatus == "在读"
        - readingDate >= date(2025-01-01)
    order:
      - formula.date_display
      - title
    sort:
      - column: formula.date_display
        direction: DESC
  - type: table
    name: 已读完成
    filters:
      and:
        - readingStatus == "已读"
        - readingDate >= date(2025-01-01)
    order:
      - formula.date_display
      - title
    sort:
      - column: formula.date_display
        direction: DESC
  - type: table
    name: 想读清单
    filters:
      readingStatus == "想读"
    order:
      - rating
      - title
    sort:
      - column: rating
        direction: DESC
      - column: title
        direction: ASC