The app provides its own built-in Console to explore the database model as well as write and execute SQL+JQL queries right within Jira.
Any JQL query can be transformed into a SQL statement with a single click from the:
Issue Navigator view > Export menu >SQL Console |
---|
Exporting from Jira is limited to 1000 issues by default in Jira. In such case, you get an error message like this:
Workaround: Remove the current JQL before exporting to the SQL+JQL console. This will make most examples stop to work as no default JQL will be available. You can set the default JQL by adding it as a parameter to the URL console (see below).
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.