1 2 3 4 5 6 7 8 9 10 11 12 13 14
| select name,classe,uri,label,description from
(Select JIResource.name,T2.label as classe,T2.uri ,JIResource.label,JIResource.description
from JIResource
inner join JIResourceFolder T2 on T2.id=JIResource.Parent_Folder
inner join JIResourceFolder T1 on T1.id=T2.parent_folder
where JIResource.id in (
Select id from JIReportUnit) and T1.id=$P{UriId}
and T2.uri in (
Select substr(jasperserver.JIObjectPermission.uri,6) as uripath from jasperserver.JIObjectPermission
inner join jasperserver.JIUser on jasperserver.JIUser.id=jasperserver.JIObjectPermission.recipientobjectid
where jasperserver.JIUser.fullname=$P{FullUserName}
and jasperserver.JIObjectPermission.recipientobjectclass like '%RepoUser'
and jasperserver.JIObjectPermission.permissionMask=30)
order by T2.label) T3 |
Partager