sql 分享 - 文档高亮部分汇总

抄 Achuan-2 大佬在语雀分享的

文档高亮部分汇总，读书笔记用

.action{$keywords := "var(--b3-font-background1)"}

**".action{.title}"**文档内
「粉红背景文字段落汇总」

{{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 -1}}

「单独以块引展示包含粉红背景文字的的标题」
.action{block:= (queryBlocks "SELECT * FROM blocks WHERE type= 'h' AND path LIKE '%/?.sy' AND markdown LIKE '%?%' ORDER BY created LIMIT -1 " .id keywords)}

.action{range v:=block}

• ((.action{v.ID} ".action{v.Content}"))
  .action{end}