嵌入块如何查询某个块的反链?
相关帖子
-
JeffreyChen • • 1
查询一个块的反链的段落块吗？试试这个（后面那个 ID 自己改）：
select * from blocks where id in ( select block_id from refs where def_block_id = "20250626220513-efmqf1k" );1 回复 -
把下面的内容保存成一个模版来调用
# 🔗 链接“.action{.title}”的内容 {{ SELECT * FROM blocks as b0 WHERE ( b0.id IN ( SELECT r1.block_id FROM refs as r1 WHERE r1.def_block_id = '.action{.id}' ) AND ( b0.type = 'h' OR b0.type = 'p' ) AND b0.parent_id NOT IN ( SELECT b1.id FROM blocks as b1 WHERE b1.type = 'i' ) ) OR ( b0.id IN ( SELECT b2.parent_id FROM blocks as b2 WHERE b2.id IN ( SELECT r2.block_id FROM refs as r2 WHERE r2.def_block_id = '.action{.id}' ) ) AND b0.type = 'i' ) order by created desc; }}1 回复 -
-
欢迎来到这里！
我们正在构建一个小众社区，大家在这里相互信任，以平等 • 自由 • 奔放的价值观进行分享交流。最终，希望大家能够找到与自己志同道合的伙伴，共同成长。
注册 关于