Jump to content

Reports are saved in the repository... but what table?

Go to solution Solved by mgeise,

Recommended Posts

I have connected to my Postgres repository using pgAdmin. I'm in the public schema of the jasperserver database. There are 86 tables and I can view the data in them. Where are the reports stored? Table jiresource looks like it might be the one. Exactly how are reports saved in the repository? I want to help our users understand that reports don't exist in the file system, and in what format they exist within the repository.

Link to comment
Share on other sites

  • Replies 3
  • Created
  • Last Reply

Top Posters In This Topic

  • Solution

You are correct that they do not reside on the filesystem.  I think what you are looking for is may be in two tables:

  • jifileresource - Report Definitions (JRXML files), Server UI stylesheets (CSS), Domain definitions and security files (XML), etc.
  • jicontentresource - Report output from scheduled report executions (PDF, HTML, XLSX, etc)

In both of these tables, the files are stored as a binary datatype in the reposotory database.

Link to comment
Share on other sites

  • 4 years later...

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...