Jasper Ideas

[Case #72427] Ability to configure Ad Hoc View Query by user role

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:

  • Guest
  • Mar 31 2021
  • To be Reviewed
Components AdHoc
  • Attach files