jiraissue table is used to store JIRA issues. Let's check the structure of this table.
It's quite easy to find the list of issues of a specific project using the JIRA Issue Navigator, but as we are exploring the database schema and its various tables, let's fetch the issues of a specific project directly from the database:
SELECT p.id AS project_id, p.pname AS project_name, CONCAT("SSP- ",ji.issuenum) AS issue_id, ji.reporter AS issue_reporter FROM project p LEFT OUTER JOIN jiraissue ji ON ji.project = p.id WHERE p.pkey = 'SSP' ORDER BY ji.issuenum;
The preceding query will display the list of issues of the project with the
SSP key. You can replace the project key with your own and try the previous query. The project name and a few other fields are fetched from the