I refer to this amazing post
It has helped me get the issue transitions i needed.
Now I want to get the issue number of these issue transitions.
Can someone tell me which table to join to and on what.
Thank you very much!
Hi @Benjamin chee_guoee ,
Please try this :
CONCAT(project.pkey, '-', jiraissue.issuenum) as issuenum,
changeitem.oldstring as oldstatus,
changeitem.newstring as newstatus,
changegroup.author as author,
changegroup.created as created
JOIN changegroup ON changeitem.groupid=changegroup.id
JOIN jiraissue ON jiraissue.ID = changegroup.issueid
JOIN project ON project.ID = jiraissue.PROJECT
Hi Benjamin - Welcome to the Community!
If you are looking for the ID of the transition itself (and not really an issue id/key) then you can find that by editing the workflow, then click on Text to see the full listing of all transitions and find the appropriate ID for it.
Catch up with Atlassian Product Managers in our 2020 Demo Den round-up! From Advanced Roadmaps to Code in Jira to Next-Gen Workflows, check out the videos below to help up-level your work in the new ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events