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!