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, ws.name AS project_associated_workflow_scheme,
wse.workflow AS workflow_scheme_associated_workflow, jw.descriptor AS workflow_descriptor
FROM project p LEFT OUTER JOIN nodeassociation na ON na.source_node_id = p.id AND na.sink_node_entity = 'WorkflowScheme'
LEFT OUTER JOIN workflowscheme ws ON ws.id = na.sink_node_id
LEFT OUTER JOIN workflowschemeentity wse ON wse.scheme = ws.id
LEFT OUTER JOIN jiraworkflows jw ON jw.workflowname = wse.workflow
WHERE p.pname = 'SBM';