JIra - log for issues , which issues have changed issue type

[Giorgi Tsitsvidze]

JIra - how can i determine , which issues have changed issue type

for example issue type was "bug" and i change it with story

how determine  this issues list , with jql or sql ... 

or somehow  without see ,one by one issues ... :) 

thanks for help , and for your time...

[Juan Manuel Ibarra · Accepted solution]

Hi Giorgi,

You can make JQL queries on historical values of some fields with the was and changed operators. See this link

Maybe you can use the CHANGED command

[Giorgi Tsitsvidze]

thanks for answer , 
i try issuetype CHANGED FROM "Bug" , but result is

"History searches do not support the 'issuetype' field. " 

[Trudy Claspill]

Right, the CHANGED and WAS operators support Assignee, Fix Version, Priority, Reporter, Resolution, and Status fields only, as per

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-operators/

There is a change request for this in Atlassian's backlog. You should add your vote to it.

https://jira.atlassian.com/browse/JRASERVER-66741

At this time the only way to get the information is to add an app to your system that provides that option. I've seen other posts on this same topic mention these apps:

JQL Tricks Plugin.

JQL Booster Pack

I have not used either of those apps.

[Giorgi Tsitsvidze]

thanks for answer Trudy , i will try this ...