Delete generated reports from Database

0

Our Jasper Server has been up for quite a long time. Due to this, some of the folders that contain the generated output reports contain a lot if files already and I'm unable to open it from the UI. I want to clean them up. I want to know how to navigate these files/directories from the database. Is there anyone who has done this? Thanks!

laggybuggy's picture
Joined: May 3 2018 - 5:40am
Last seen: 11 months 1 week ago

1 Answer:

0

These are the following tables involved for deletion:

  • JICONTENTRESOURCE
  • JIRESOURCE

You can also check the following to filter down your search results:

  • JIRESOURCEFOLDER

Sample Query:

SELECT *
FROM JIRESOURCE rsrc
LEFT JOIN JIRESOURCEFOLDER folder
ON rsrc.parent_folder = folder.ID
LEFT JOIN JICONTENTRESOURCE conrsrc
ON rsrc.ID = conrsrc.ID
WHERE folder.URI = '/FolderName'

laggybuggy's picture
Joined: May 3 2018 - 5:40am
Last seen: 11 months 1 week ago
Feedback
randomness