How to enable View SQL query button in Ad Hoc Editor under Advance Reporting Link

Document ID : KB000032755
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

Sometimes while creating Ad Hoc views via Advance Reporting you would want to see the query. There is a button called View SQL query in the Ad Hoc Editor but that is disabled by default. How can we enable this feature?

Pic 1.jpg

Steps to Reproduce:

  1. Login to CA PPM and Navigate to Advance Reporting
  2. Create an Ad Hoc View using a Domain
  3. Notice the arrow View SQL query button is disabled 

  

Answer: 

  1. To enable the same you need to login to Jaspersoft Console using superuser account
  2. Navigate to Manage tab and Click on Server Settings
  3. In the Server Settings Click on Ad Hoc Settings
  4. Under Ad Hoc Settings check the Enable view Query in Ad Hoc Editor and chick on Change button to take effect

 

Pic3.jpg

 

After making this change, refresh the CA PPM and you can see the button called 'View SQL Query' in the Ad Hoc View Editor is enabled now.

Pic4.jpg 

 

Additional Information:

Visit the Jaspersoft Community