笔记归档展示 (二)—展示最近一周、最近一个月创建的文档
有群友提出了新的想法,想展示最近一周和最近一个月创建的文档。
通过以下SQL,可以实现上面的需求
实现
最近一周
select
'[' || b.content || '](siyuan://blocks/' || b.id || ')' AS __1____pre__文档标题,
replace(tag,'#','') as __2__标签 ,
b.created as __3____date__创建时间
-- b.hpath AS __5__文档路径
from
blocks b
where
b.type = 'd'
-- 限定时间在一周内
and b.created > strftime('%Y%m%d%H%M%S',datetime('now','-7 day'))
order by
b.created desc
最近一个月
select
'[' || b.content || '](siyuan://blocks/' || b.id || ')' AS __1____pre__文档标题,
replace(tag,'#','') as __2__标签 ,
b.created as __3____date__创建时间
-- b.hpath AS __5__文档路径
from
blocks b
where
b.type = 'd'
-- 限定在一个月内
and b.created > strftime('%Y%m%d%H%M%S',datetime('now','-1 month'))
order by
b.created desc