Find all Jira issue in Database

MySQL / PostgreSQL

SQL

-- 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