JQL to identify the list of items whose defect severity has changed

Question

Hi All,

I would like to get a report on list of items that has changed its defect severity value, for example Medium to High.

I found on internet that 'Changed' can be applied but it is limited to only few attributes like Assignee,status and Priority as per the below link.

https://confluence.atlassian.com/jiracore/blog/2015/07/search-jira-like-a-boss-with-jql

I am looking similarly for Defect Severity but unable to get. Any information provided will be really helpful.

Thanks,

Vijay

Ligia Merciu · Answer

Hi,

In the answer above, you may replace

fieldHistory(key, "priority")

with

fieldHistory(key, "Your customfield name")

or

fieldHistory(key, "Your_customfield_id")

no matter what it would be, as long as it is a JIRA customfield or other supported customfield.

Ana-Maria Gologan · Answer

Hi,

You could achieve this with SIL JQL Search. For that you need to use this JQL:

key in silJQLExpression('arrayElementExists( fieldHistory(key, "priority"), 3) ', 'project = TEST') and priority = High

Where 3 is the priority id for "Medium" in my JIRA. You need to see what is you priority id for "Medium" in your JIRA.

You can find more JQL searches here: https://confluence.cprime.io/display/TR/SIL+JQL+Search

Also, you can read more about SIL Routines here:

https://confluence.cprime.io/display/SIL/Routines

Best Regards,

Ana

M Vijay Kumar · Answer

Hi Sam,

Yes it is one of the custom field assigend to defect.

Thanks,

Vijay