...
Code Block |
---|
-- 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; |
...
...
Code Block |
---|
-- 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; |
...