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!
These are the following tables involved for deletion:
You can also check the following to filter down your search results:
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'