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

Rai_Gursharan May 3, 2024

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.

2 answers

0 votes
agilsrinivasan
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 8, 2024

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.

0 votes
Ankit Srivastava
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.
May 3, 2024

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

Rai_Gursharan May 3, 2024

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.

Like Ankit Srivastava likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events