In Ad Hoc, you can enable users to see the Adhoc Views' queries.
Manage -> Server Settings -> Adhoc Settings -> Configure View Quey and then checked the "Enable View Query in Ad Hoc Editor" option.
Then, logged with a user with ROLE_ADMINISTRATOR we can see the generated query after clicking the "View SQL Query" button.
However, this feature is not available to just ROLE_USER. Customer is asking for the following:
"Ideally we want to configure specific external roles to allow users view query. But in the worst case it would be ok that all users with internal ROLE_USER can view the query."
Issue environment: JS v6.3.0 bundled Tomcat/postgresql on Windows.
Jasper Product + version:
App server + version:
DB + version:
JVM version:
Operating system + version:
Browser + version:
Components | AdHoc |