Skip to content

Instantly share code, notes, and snippets.

@dorkness-io
Created April 9, 2020 15:04
Show Gist options
  • Save dorkness-io/ff6c78bc5f481598a843cd0adc380d4b to your computer and use it in GitHub Desktop.
Save dorkness-io/ff6c78bc5f481598a843cd0adc380d4b to your computer and use it in GitHub Desktop.
select
p.pkey || '-' || ji.issuenum AS issue_key
,ja.actionbody
from jiraissue ji
inner join project p
on ji.project = p.id
inner join jiraaction ja
on ji.id = ja.issueid
and actiontype = 'comment'
where p.pkey = 'TP';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment