How to write a jql query to list all the downgraded incidents

Question

How to write a JQL query to list all the downgraded incidents and create a dashboard to see the list of all the downgraded incidents.

agilsrinivasan · Answer

project = "Incident Management" AND "Incident Priority" not in (P1-Critical, P2-High, P0-Catastrophic) AND (labels is EMPTY OR labels = nocbypass:false) AND status not in (Resolved, Closed, Cancelled) AND type = Incident AND "Reason for Priority Change" is not EMPTY AND "Priority Change Type" = "Major to Minor" AND createdDate > startOfDay(-7)

This query might help further more to filter the tickets which were downgraded from major priority to minor priority and to check for only the past 7 days.

Rai,Gursharan · Answer

project = "Incident Management" AND "Incident Priority" not in (P1-Critical, P2-High, P0-Catastrophic) ) AND status not in (Resolved, Closed, Cancelled) AND type = Incident AND "Reason for Priority Change" is not EMPTY

Used the above query to solve the purpose, Thanks for your input.

Ankit Srivastava_3e9eks · Answer

Hi @Rai,Gursharan ,

Welcome to the Atlassian Community!

Please refer the below JQL Syntax:
project = "Project Name" and priority = downgraded and issuetype = incident

If downgraded is a custom field then, 
project = "Project Name" and downgraded = "Value" and issuetype = incident

Save this JQL as filter and then use it in gadget for your dashboard reporting.

You may use PI-Chart, Filter Results gadget on your dashboard.

Or

You may use the JQL syntax (list all the incident as priority wise)

project = "Project Name" and issuetype = incident
and use Pi-chart gadget and select Priority as category

Hope this will help.

Thanks,
Ankit Srivastava