Search Issues that have changed Issue Type

Rob B
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 2, 2022

Is there some SQL to search for issues that have had their issue type changed?

Thanks

2 answers

0 votes
Pramodh M
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 2, 2022

Hi @Rob B 

JQL Tricks Plugin allows us to search for the issues that have changed issue type

Here's the link

https://marketplace.atlassian.com/apps/31399/jql-tricks-plugin?tab=overview&hosting=datacenter

Thanks

Pramodh

0 votes
AMIT GULATI February 2, 2022

Hi Robert, Standard JQL doesnt seem to allow this but just curious about this need. What is the reason to look for such issues?

Joshua Vosper February 26, 2024

Amit, I can share my use case.

As a Scrum Master, I want to see the increase in issues, and their respective Story Points, for a specific team given a specific time period.

What JQL allows me to to now is find issues that have been created on or after a specific date. I then tally their respective Story Points.

What JQL does NOT allow me to do is find Sub-task that were created before a specific date, but was then converted to something other than a Sub-task on or after a specific date.

From my end, I am very interested in discovering these converted Sub-tasks, and in turn tallying their respective Story Points.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
8.0
TAGS
AUG Leaders

Atlassian Community Events