思源笔记丨使用 Query 获取今年所有新建的笔记

我的新建文档和块引新建文档存放位置都放在 Notes 笔记本里，按月份存放

但是查看的时候不是特别方便，得一个月一个月查看

所以想了一个方法，可以用 Query 插件，直接获取今年所有笔记

SELECT 
    '[' || b.content || '](siyuan://blocks/' || b.id ||')' as __01____pre__文档, 
    created as __02____datetime__创建时间,
    updated as __03____datetime__更新时间
FROM blocks as b
WHERE type = 'd'
  AND box = '20241028223353-d3d8gan'
  AND hpath like '.root{.hpath}/%' 
  AND NOT ( -- 排除月笔记文件夹
      b.content REGEXP '^[0-9]{4}$'  -- Matches a 4-digit year
      OR b.content REGEXP '^[0-9]{6}$'  -- Matches a 6-digit year and month
  )
ORDER BY created DESC Limit -1;