We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.
Our Support systems migrated on Saturday, May 21. We'll automatically forward you to the new location for this content.

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')

Comments

0 comments

Please sign in to leave a comment.