[How to determine referenced resources that prevent you from deleting a Domain]

If ERROR: relation "jiadhocdataview" does not exist then remove the union with adhoc view.  (Community edition?)

 

SELECT
 
jiresource.label AS "dependant_resource_label",
jiresource.resourcetype, jiresourcefolder.uri AS "parent_folder_path",
jiresourcefolder.name AS "parent_folder_name"
 
FROM
 
jiresource LEFT OUTER JOIN jiresourcefolder ON (jiresource.parent_folder = jiresourcefolder.id)
 
WHERE
 
jiresource.id IN (SELECT id FROM jireportunit WHERE
reportdatasource='22824');

 

I installed PGAdmin on the Jasper server and used:

Database Name:  jasperserver

Username:  postgres

Password:  postgres