Hello there,
Continuing on from my other posts as I am building my knowledge up on Jira and SQL.
Currently, I have a string which works fine to filter out tickets that I don't need to see, however, it has come to my attention that some tickets have not been shown due to having two environments, one of which is the one that I have marked as exclude from the search results. How would I go about including tickets that have two environments but one of those said environments is the environment that I am currently trying to exclude?
Currently, my string looks like this:
Project = A1 AND "A1 Environments" != SIT AND issuetype in (Bug, Defect) AND status = Open ORDER BY key ASC, priority DESC, update DESC
SIT is the environment that is currently being excluded and my current string works well to exclude the tickets that contain the SIT environment, however, when a ticket comes in with for example PROD and SIT, the ticket is excluded - Is there a way to show these tickets but not show all tickets that just contain the SIT environment in them?
Thank you.
