Inbox Database

Inbox 数据库

filters:
  and:
    - file.folder.startswith("0-Inbox")
    - status != "已归档"
formulas:
  created_display: if(created, created.format("yyyy-MM-dd HH:mm"), "")
  outlinks_count: length(file.outlinks)
  inlinks_count: length(file.inlinks)
  status_priority: if(status == "进行中", 1, if(status == "待处理", 2, if(status == "已完成", 3, 4)))
properties:
  title:
    displayName: 标题
  formula.created_display:
    displayName: 创建时间
  status:
    displayName: 状态
  priority:
    displayName: 优先级
  category:
    displayName: 分类
  tags:
    displayName: 标签
  formula.outlinks_count:
    displayName: 出链数
  formula.inlinks_count:
    displayName: 入链数
views:
  - type: table
    name: 全部项目
    filters:
      and:
        - file.folder.startswith("0-Inbox")
        - status != "已归档"
    order:
      - formula.status_priority
      - priority
      - formula.created_display
    sort:
      - column: formula.status_priority
        direction: ASC
      - column: priority
        direction: ASC
      - column: formula.created_display
        direction: DESC
  - type: table
    name: 待处理
    filters:
      and:
        - file.folder.startswith("0-Inbox")
        - status == "待处理"
    order:
      - priority
      - formula.created_display
    sort:
      - column: priority
        direction: ASC
      - column: formula.created_display
        direction: DESC
  - type: table
    name: 进行中
    filters:
      and:
        - file.folder.startswith("0-Inbox")
        - status == "进行中"
    order:
      - formula.created_display
      - title
    sort:
      - column: formula.created_display
        direction: ASC
      - column: title
        direction: ASC
  - type: table
    name: 已完成
    filters:
      and:
        - file.folder.startswith("0-Inbox")
        - status == "已完成"
    order:
      - formula.created_display
      - title
    sort:
      - column: formula.created_display
        direction: DESC
      - column: title
        direction: ASC