FineBI5.1通过FineDB表获取挂出目录完整路径

本地已按照教程配置数据连接：https://help.fanruan.com/finebi5.1/doc-view-1080.html

现在想通过FineDB 表获取到挂出目录的完整路径，如下图

目录路径：管理驾驶舱-住房公积金可视化驾驶舱

通过

SELECT * FROM FINE_AUTHORITY_OBJECT WHERE displayname='住房公积金可视化驾驶舱'

只能获取到挂出的报表名，但是没有完整的目录路径，请问在哪个表可以获取到

FineBI luozhiwei 发布于 2023-8-25 14:38

1min目标场景问卷

立即参与

回答问题关注问题

悬赏：4 F币 + 添加悬赏

提示：增加悬赏、完善问题、追问等操作，可使您的问题被置顶，并向所有关注者发送通知

共2回答

最佳回答

luozhiweiLv5见习互助
发布于2023-8-28 11:45

SELECT REPLACE(c,'Dec-Entry_Management-','') as C FROM ( SELECT CASE WHEN SUBSTR(C,LENGTH(C),1) = '-' THEN SUBSTR(C,1,LENGTH(C)-1) ELSE C END AS C FROM ( SELECT CASE WHEN SUBSTR(C,LENGTH(C),1) = '-' THEN SUBSTR(C,1,LENGTH(C)-1) ELSE C END AS C FROM (SELECT CASE WHEN SUBSTR(C,LENGTH(C),1) = '-' THEN SUBSTR(C,1,LENGTH(C)-1) ELSE C END AS C FROM (SELECT CASE WHEN SUBSTR(C,LENGTH(C),1) = '-' THEN SUBSTR(C,1,LENGTH(C)-1) ELSE C END AS C FROM (SELECT CASE WHEN SUBSTR(C,LENGTH(C),1) = '-' THEN SUBSTR(C,1,LENGTH(C)-1) ELSE C END AS C FROM (SELECT t1.displayname||'-'||nvl(t2.displayname,'')||'-'||nvl(t3.displayname,'')||'-'||nvl(t4.displayname,'')||'-'||nvl(t5.displayname,'') AS C FROM FINE_AUTHORITY_OBJECT t1 left join FINE_AUTHORITY_OBJECT t2 on t1.ID = t2.PARENTID left join FINE_AUTHORITY_OBJECT t3 on t2.ID = t3.PARENTID left join FINE_AUTHORITY_OBJECT t4 on t3.ID = t4.PARENTID left join FINE_AUTHORITY_OBJECT t5 on t4.ID = t5.PARENTID WHERE t1.EXPANDTYPE='3'))))))