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]

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).