/
Find all Jira issue in Database
Find all Jira issue in Database
MySQL / PostgreSQL
-- Find Jira Issue SELECT CONCAT(p.pkey,'-',ji.issuenum) AS "issuekey", ji.summary, ji.description, ji.assignee, ji.creator, ji.created, ji.updated FROM jiraissue ji JOIN project p ON ji.project = p.id;
All column named IssueKey will be auto converted into issue link when displaying as result
Sample Result
issuekey | summary | description | assignee | creator | created | updated |
---|---|---|---|---|---|---|
SQLREPORT-24 | Allow export of searched results in SQL Reports | To export only searched results instead of all results in SQL Reports. | admin | admin | 2019-01-31 09:24:33 | 2020-02-26 14:22:31 |
SQLREPORT-25 | Allow filter of SQL Report results based on columns | To add filter based on columns. | admin | admin | 2019-02-11 11:13:23 | 2020-03-15 13:11:29 |
SQLREPORT-27 | Allow User to create SQL query from SQLReporter UI | To allow Jira Administrators to upload new SQL queries via the Web UI | admin | admin | 2019-11-12 16:22:43 | 2020-07-13 10:12:25 |
Related content
Adding a new SQL report configuration
Adding a new SQL report configuration
Read with this
Finding No. Issues for every project
Finding No. Issues for every project
More like this
How to upload SQL files into SQL Reporter for Jira
How to upload SQL files into SQL Reporter for Jira
Read with this
SQL Reporter for Jira Home
SQL Reporter for Jira Home
More like this
How to view your SQL Report
How to view your SQL Report
Read with this
Release Notes for 1.2.0
Release Notes for 1.2.0
More like this