Jaspersoft report storage location

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Where are Jaspersoft reports file stored in a database?

Environment

All Release

Resolution

The Reports are stored in tables such as JIFileResource and JIContentResource but we cannot run a SELECT SQL and extract the report.
We have to use the Export functionality.
There are dependencies and the report data is not stored in a human readable format