How to Find Number of Adhocs created by using Domain

In Jasper server we have a lot of adhoc views created by using domains
If we modify any changes to the domain then all these adhoc views will effect. Then we don’t know how many adhocs were effected.
In order to find the no of adhocs effected by using the domain
we need to follow below the steps

1. Open Jasper server
2. Click on Create domain
3. Select the Audit Data source connection
4. Click on data management
5. Create derived table and add the below query

SELECT r.name AS Domain_Name, rf.name AS Folder_Name, r2.name AS Adhoc_View_Name
  FROM jiresource r, jiadhocdataview adv, jiresource r2, jiresourcefolder rf
 WHERE adv.reportdatasource = r.id
   AND r2.id = adv.id
   AND r.resourcetype ='com.jaspersoft.commons.semantic.datasource.SemanticLayerDataSource'
   AND r2.parent_folder = rf.id
ORDER BY r.name, rf.name, r2.name;

6. Run the query and add the fields into the Data Presentation

7. Save the domain
8. Click on create adhoc and select the above domain
9.Add the fields to the columns section
10. Click on the domain_name field and add the filter
11. Select the particular domain in the filters list and apply it

Thank You,
Raju Vudugula
Helical IT Solutions

Best Open Source Business Intelligence Software Helical Insight is Here

A Business Intelligence Framework

Free
Download