【模板】汇总所有包含关键词的块

只需要改第一行的keywords变量内的“关键词”为自己需要的词语，就可以通过使用模板查找关键词了，对于标题是用块引方式展现。
可以根据自己的需要建立一个关键词文件夹，对该模板复制几份，改成不同的常用关键词

汇总本文档内包含关键词的内容块

.action{$keywords := "关键词"}
.action{.title}文档内包含关键词(.action{$keywords})的段落文字汇总
{{SELECT * FROM blocks WHERE path LIKE '%/.action{.id}.sy' AND markdown LIKE '%.action{$keywords}%' AND  (type = 'p' AND parent_id not in (SELECT id FROM blocks WHERE path LIKE '%/.action{.id}.sy' AND type = 'i') )  OR (type = 'i' AND id in (SELECT parent_id FROM blocks WHERE path LIKE '%/.action{.id}.sy' AND type ='p' AND markdown LIKE '%.action{$keywords}% ' )) ORDER BY created LIMIT 10000 }}

md文件
doc_contain_keywords.md

汇总所有子文档内包含关键词的内容块

.action{$keywords := "关键词"}
子文档内包含关键词(.action{$keywords})的段落文字汇总（不包含本文档）
{{SELECT * FROM blocks WHERE path LIKE '%.action{.id}/%' AND markdown LIKE '%.action{$keywords}%' AND  ((type = 'p' AND parent_id not in (SELECT id FROM blocks WHERE  type = 'i') )  OR (type = 'i' AND id in (SELECT parent_id FROM blocks WHERE  type ='p' AND markdown LIKE '%.action{$keywords}%' )) ) ORDER BY created LIMIT 10000 }}
单独以块引展示包含关键词(.action{$keywords})的标题
.action{$block:= (queryBlocks "SELECT * FROM blocks WHERE type= 'h' AND path LIKE '%?/%'  AND markdown LIKE '%?%'  ORDER BY created LIMIT 10000" .id $keywords)}
.action{range $v:=$block} 
- ((.action{$v.ID} ".action{$v.Content}")) (.action{$v.HPath})
.action{end}

subdoc_contain_keywords.md

汇总所有文档内包含关键词的内容块

搜索所有文档中包含关键词的内容，但不包括此文档

.action{$keywords := "关键词"}
所有文档内包含关键词(.action{$keywords})的段落文字汇总（不包含本文档）
{{SELECT * FROM blocks WHERE path NOT LIKE '%/.action{.id}.sy' AND markdown LIKE '%.action{$keywords}%' AND  ((type = 'p' AND parent_id not in (SELECT id FROM blocks WHERE  type = 'i') )  OR (type = 'i' AND id in (SELECT parent_id FROM blocks WHERE  type ='p' AND markdown LIKE '%.action{$keywords}%' )) ) ORDER BY created LIMIT 10000 }}
单独以块引展示包含关键词(.action{$keywords})的标题
.action{$block:= (queryBlocks "SELECT * FROM blocks WHERE type= 'h' AND path NOT LIKE '%/.action{.id}.sy' AND markdown LIKE '%?%'  ORDER BY created LIMIT 10000" $keywords)}
.action{range $v:=$block} 
- ((.action{$v.ID} ".action{$v.Content}")) (.action{$v.HPath})
.action{end}

all_contain_keywords.md.md