Database Query | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
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;
|
Database Query | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
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';
|