Bug Filtering - Report on Defect's Highest Environment by Excluding Lower Environments

Calum Mitchell

Hello Atlassian Community,

 

I've been tasked with editing some filters and am particularly struggling with the below requests to report on a defect's highest known environment only by excluding the lower environments (where applicable):

• If PROD defect is also in UAT & SIT, exclude UAT & SIT to only report PROD
• If SIT defect is also in UAT, exclude SIT to only report UAT

Any assistance would be greatly appreciated, thank you! 

Mercy_dt1a1g

Jira’s native JQL can’t “rank” values within a field and automatically suppress lower-priority matches, so to report only the highest environment for each defect you’ll need either a calculated field or automation to capture that logic before filtering. A common approach is to add a custom single-select field such as **Highest Environment** and use an [automation rule](https://support.atlassian.com/cloud-automation/docs/jira-automation-triggers/) triggered when the Environment field changes to set this to the highest applicable value based on your hierarchy (e.g. PROD > UAT > SIT).