Sample SQL Query to List All Report Units Folder by Folder in JRS Repository DB - Code Sample - Jaspersoft Community

Jump to content

We've recently updated our Privacy Statement, available here ×

Sample SQL Query to List All Report Units Folder by Folder in JRS Repository DB
By Tom C

April 26
Features: JasperReports Server, Reports, Repository Version: v9.0.0 Product: JasperReports® Server
Share

Followers 1
select f.uri as "Report Folder" , r.name as "Report Name" , r.label as "Report Reference" from jiresource r inner join jireportunit u on u.id = r.id inner join jiresourcefolder f on f.id = r.parent_folder order by 1

reportList.xlsx

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

20240426-TTC-2255650
Table of contents
Share
Followers 1
Go to entries

User Feedback
- 0 Comments
Recommended Comments

There are no comments to display.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!
Register a new account

Sign in

Already have an account? Sign in here.
Sign In Now

×

×

Create New...