Identify All Report Units Which Use a Repository Input Control

The following SQL query will help user to identify all report units which have assigned an Input Control stored in TIBCO JasperReports^® Server repository:

SELECT 
    ic.name as InputControlName, rf.uri as ReportURI, rep.name as ReportName
FROM 
    jireportunitinputcontrol ru,
    jiresource rep,
    jiresource ic,
    jiresourcefolder rf

where
    ru.input_control_id = ic.id
    and ru.report_unit_id = rep.id
    and rep.parent_folder = rf.id
    and ic.resourceType = 'com.jaspersoft.jasperserver.api.metadata.common.domain.InputControl'
    and ic.name = 'test_ic' -- specify required input control name here

This query can be used to assist in the effort to determine related reports if a user needs to delete an input control from the repository but the operation fails with message

The selected items cannot be deleted because they are referenced by other objects.

The query tested with TIBCO JasperReports^® Server v.7.1.0 and PostgreSQL repository database

Ref. Case 01656654