Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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:

...

Since the 9.6.0 version, the action to open the SQL+JQL console is automatically hidden for non-trusted users.


Check installation

Run a simple benchmark by running this query:

Code Block
languagesql
themeEmacs
WITH RECURSIVE T(N) AS (
    SELECT 1
    UNION ALL
    SELECT N+1 FROM T WHERE N<50000
)
SELECT count(*) FROM T;


The query above creates 50K records in H2 and counts them. This is the average result from our development environment:

COUNT(*)
50000

(1 row, 20 ms)

It might help you to see how fast SQL+JQL will perform on your Jira.


Run some built-in examples from the built-in console to learn about SQL+JQL queries.

Troubleshooting

If you run into some problem, then please read theĀ Troubleshooting section to verify that the core features work as expected.

...