How to write a JQL to find IssueType changed on Last one month

[Anil Kumar]

As per document mentioned on below page WAS, WAS IN operator not supported for Issue Type. Is anyone here have any alternate/workaround to find issue list where issue type changed.

https://confluence.atlassian.com/jiracorecloud/advanced-searching-fields-reference-765593716.html

Use case - Operation team raise Field Issue for error found in process & product team review and if required update issue type from Field Issue to Story to bring that as product feature. We are looking to fetch list of work item converted from "Field Issue" to product "Story".

Looking for suggestion without any add-on :) 

[Anil Kumar]

FYI-

from database we can fetch this details as below, how to achieve same on Cloud Instance.

select * from <db name>.<schema name>.changeitem where FIELD='issuetype'

[Tarun Sapra]

Hello @Anil Kumar 

I don't think it's possible to do this even with plugin on cloud. With Script runner plugin you can achieve it on server but with cloud I am not sure if you can achieve this. 

Also, on Cloud you don't have access to DB hence you can't execute the DB queries yourself.