Delete generated reports from Database

[laggybuggy]

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]

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 rsrcLEFT JOIN JIRESOURCEFOLDER folderON rsrc.parent_folder = folder.IDLEFT JOIN JICONTENTRESOURCE conrsrcON rsrc.ID = conrsrc.IDWHERE folder.URI = '/FolderName'[/code]