Is there a JQL to list tickets converted from service request to incident issue type?

[Zaldy Parian]

Hi all,

I hope someone can help me with this question. We wanted to check which tickets have been changed by our users from SR to Incident issue type.  I can only see it if I go through each record and check the History tab. But it is very time consuming.

Is there a quick and easy way to do this via JQL?

Regards,

[Yuliia_Borivets__SaaSJet_ · Accepted solution]

Hi @Zaldy Parian 

JQL doesn't support history searches for the issue type field. 

I can suggest trying Issue History for Jira app as an alternative solution. It records changes for any issue type in a convenient list view. With a bunch of filters and columns editor, you can customize the report according to your needs. 

My team created this app as a diary for everyday updates made by the users. Here is an example of the report. Issue type changes are visible in a separate column.

There is a 30-day free trial, so you can check if the app fits your needs. Let me know if this solution helps or if you have any questions.

[Mohamed Benziane · Accepted solution]

Hi,

Unfortunately you can't do it via JQL. May be you can create a new field "old issuetype" and look for an automation rule that will fill this field everytime the issuetype change.

[RVS_Support]

Hi @Zaldy Parian 

As an alternative, you can try out our app.

Issue History Reports

You can view the complete change log for your filtered issues along with issue key changes as in the screen below. 

Do Try it out.

Disclaimer : I am part of the team which developed this app