Child pages (Children Display)
The app provides its own built-in Console to explore the database model as well as write, execute, and execute save SQL+JQL queries right within Jira.Any JQL query can be transformed into a SQL statement with a single click from the:
| Info |
|---|
In the 9.6.0 version, the location to open the console was moved from the Export Menu to the Top page menu. |
| Issue Navigator view > Export menu >SQL Console |
|---|
...
| SQL+JQL action in the top menu |
|---|
Exporting from Jira is limited to 1000 issues by default in Jira. In such case, you get an error message like this:
...
The SQL console can also be opened from your browser by using the following link:
| ${JIRA_BASE_URL}/secure/JDBC4JQLDBConsole!default.jspa |
|---|
Optionally, a JQL can be provided as URL parameter:
| ${JIRA_BASE_URL}/secure/JDBC4JQLDBConsole!default.jspa?jql=<your JQL here> |
|---|
As SQL for JIRA re-uses the JIRA HTTP session you have to login in JIRA from your browser prior to access to the SQL console.
