We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

Articles in this section

See more

SQL query to list Perceive Reports and Ad-hoc Views

Avatar
Gerard Cafaro
Follow

The SQL query below will list the following information about Perceive reports and ad-hoc views. The query can be run from the SQL console or directly against the Perceive database.

  1. Name
  2. Description
  3. Date created
  4. Date updated
SELECT * 
FROM JIResource
WHERE resourceType IN ('com.jaspersoft.jasperserver.api.metadata.jasperreports.domain.ReportUnit','com.jaspersoft.ji.adhoc.AdhocDataView')

Related articles

Comments

0 comments

Please sign in to leave a comment.