...
Finally, create a pool of trusted users to write, run and save queries for the rest of the organization by granting them access to the built-in SQL console or remotely via JDBC:
Impact on the Jira GUI
One of the biggest administrators's concerns is how the Jira GUI is impacted by the app as this might confuse many users with new menus, etc. The impact of the app is minimal so the users should not be aware of anything new has been installed. Only very few and specific changes can be perceived by some users:
- A new sql() function is available from the Search Issues text area (in advanced mode) on the Issue Navigator when they type "s" in some JQL.
- Two new gadgets (SQL+JQL Flat and Pivot tables) are available when a user searches for gadgets to be added to a Jira Dashboard.
SQL+JQL is really a non-intrusive app and most of the users will be not impacted by the changes mentioned above.
Since the 9.6.0 version, the action to open the SQL+JQL console is automatically hidden for non-trusted users.
Check installation
Run some built-in examples from the built-in console.
...