查询报表目录

select id1,id2,id3,id4,concat(lv1, '/', lv2,  concat( '/', lv3 ), concat( '/', lv4 )) as dictory ,lv1 ,lv2 ,lv3 ,lv4 ,paths from

(select a.id as id1,b.id as id2,c.id as id3,d.id as id4,a.displayName as lv1 ,b.displayName as lv2 ,c.displayName as lv3 ,d.displayName as lv4 ,ifnull( ifnull( b.path, c.path ), d.path ) as paths from fine_authority_object a

left join fine_authority_object b on a.id = b.parentId

left join fine_authority_object c on b.id = c.parentId

left join fine_authority_object d on c.id = d.parentId

where a.parentid = 'decision-directory-root'

order by a.sortIndex ) a

=============

在fineDB里面，替换这个文件夹即可

请问finedb如何迁移

https://bbs.fanruan.com/wenda/question/153354.html 参考