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

M Vijay Kumar April 6, 2017

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

 

4 answers

0 votes
Ligia Merciu April 11, 2017

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.

0 votes
Ana-Maria Gologan April 6, 2017

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

0 votes
M Vijay Kumar April 6, 2017

Hi Sam,

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

 

Thanks,

Vijay

0 votes
Sam Hall
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.
April 6, 2017

Hi Vijay - 'Defect Severity' isn't a standard JIRA field. Is this a custom field you have added to your JIRA project(s)? 

Suggest an answer

Log in or Sign up to answer