这个不支持直接导出

可以去后台sql查询下

对应sql参考

查询报表目录

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

=========

=========

或者

权限导出插件-https://help.fanruan.com/finereport/doc-view-3508.html

select 

a.displayName,

    REPLACE(group_concat(b.displayName separator '-'),'Dec-Entry_Management-','') film_star -- 拿到的值用逗号拼接起来

from (

SELECT

    distinct fi.id, -- 可以关联的列id

fi.displayName,

    substring_index( substring_index( CONCAT(fi.fullPath,"-_-" ,fi.id), '-_-', b.help_topic_id + 1 ), '-_-', - 1 ) film_star  -- 被拆分的列

FROM

    fine_authority_object fi

    JOIN mysql.help_topic b ON b.help_topic_id < ( 

        length( CONCAT(fi.fullPath,"-_-" ,fi.id) ) - length( REPLACE ( CONCAT(fi.fullPath,"-_-" ,fi.id), '-_-', '' )) + 3 

    ) 

WHERE  fi.expandType=102

) a 

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

group by a.id,a.displayName -- 按id分组

资源迁移目录