Page History

SELECT 
issuenum, issuestatus.pname, reporter, assignee, issuetype, summary
   
FROM 
jiraissue, issuestatus
   
WHERE project = (select id from project where pkey='SBM')

     AND issuestatus.id = jiraissue.issuestatus 
   ORDER BY issuenum;

SELECT 
p.id AS project_id, 
p.pname AS project_name, 
p.lead AS project_lead,
ji.pkey AS issue_id, 
ji.reporter AS issue_reporter, 
pri.pname AS issue_priority, 
ist.pname AS issue_status, 
ji.summary AS issue_summary
FROM jiraissue, issuestatus
   WHERE project = (select id from project where pkey='SBM')
     AND issuestatus.id = jiraissue.issuestatus 
   ORDER BY issuenum;