You can use this SQL to get issues with changed issuetype
Select project.pkey + '-' + CAST(jiraissue.issuenum as varchar(20)) , changeitem.* , changegroup.* from changeitem join changegroup join jiraissue join project on jiraissue.PROJECT = project.ID on changegroup.issueid = jiraissue.ID on changeitem.groupid = changegroup.ID where changeitem.FIELD like 'issuetype' order by changegroup.CREATED asc
Yes. When you change an issue, whether it's a single edit or a bulk-edit (including move, edit, transition etc), JIRA re-indexes the issues affected.
If a user has a page open with a dashboard report or query open, it won't be refreshed with changed data, but the next time they use it, it will re-read the issues and hence work off the newly indexed data.
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
Every time you release software, there's a bit of risk – that there's a bug, that something breaks, or that the feature doesn't resonate with customers. Feature flagging helps make high stakes s...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG