sql 筛选任务列表，命令：where type='i' and subtype= 't' and path like "%20211025140243-y1q7v8d%" and markdown like "%[ ]%")，出来的结果多个层级的任务各自独立成为结果项输出了。有没有办法属于同一个任务树的任务按照任务树的格式只出现一次？
子任务的 parent_id 和父任务的 id 不同，不能通过这一条筛
sql 筛选层级任务的问题
本贴最后更新于 1246 天前，其中的信息可能已经斗转星移
相关帖子
-
-
duyujie •作者
获取 20211025101231-27gd4vy 下的未完成任务：
select * from blocks where id in (select id from (select id,parent_id as id1 from blocks where path like '%20211025101231-27gd4vy%' and type='i' and subtype='t' and markdown like '%* [ ]%') as a left join (select id as id1,parent_id as id2 from blocks) as b on a.id1=b.id1 where b.id2 not in (select id from blocks where path like '%20211025101231-27gd4vy%' and type='i' and subtype='t' and markdown like '%* [ ]%'));
-
duyujie •作者
{{select * from blocks where id in ( select id from ( select id,parent_id as id1 from blocks ) as a left join ( select id as id1,parent_id as id2 from blocks ) as b on a.id1=b.id1 where b.id2 not in ( select id from blocks where type='i' ) ) and type='i' and subtype='t' and markdown like '* [ ] %'}}
欢迎来到这里！
我们正在构建一个小众社区，大家在这里相互信任，以平等 • 自由 • 奔放的价值观进行分享交流。最终，希望大家能够找到与自己志同道合的伙伴，共同成长。
注册 关于