Search filter displaying results for incorrect project

[diana.pereira]

Hi!

I want to create a search filter for a particular project (let's call it PX1 for the query purposes) and use an OR argument in the environment field. This field is free text and can contain any words and/or be blank.

When I search using just this query

project = PX1 AND issuetype = Bug AND status in (Open, "Development in Progress", "Code Review", "QA In Progress") AND environment ~ prod OR environment ~ UAT

only bugs from the project PX1 are being displayed, however, when I add the OR argument with the "EMPTY" field, results from other projects are also displayed

project = PX1 AND issuetype = Bug AND status in (Open, "Development in Progress", "Code Review", "QA In Progress") AND environment ~ prod OR environment ~ UAT OR environment is EMPTY

How can I solve this issue?

[Jack Brickey]

Regarding other projects you need to add parentheses...

project = WC1 AND (issuetype = Bug AND status in (Open, "Development in Progress", "Code Review", "QA In Progress") AND environment ~ prod OR environment ~ UAT OR environment is EMPTY)

[diana.pereira]

Thanks @Jack Brickey. Editing my comment as I incorrectly applied the wrong search query!! Apologies...

It works!!! Awesome. :)

[Jack Brickey]

Great!

[diana.pereira]

I spoke too soon... Now I'm getting not only bugs but also stories, sub-tasks... the lot. It seems that although the environment query is working, the issuetype is not...

[Jack Brickey]

If you only want bugs then use this

project = WC1 AND issuetype = Bug AND (status in (Open, "Development in Progress", "Code Review", "QA In Progress") AND environment ~ prod OR environment ~ UAT OR environment is EMPTY)

basically move the bug argument outside of () 

[diana.pereira]

Awesome! I think I get the logic now.

I've changed it for:

project = WC1 AND issuetype = Bug AND status in (Open, "Development in Progress", "Code Review", "QA In Progress") AND (environment ~ prod OR environment ~ UAT OR environment is EMPTY)

 to only get bugs with the above statuses and got the number that I expected. YAY!

Thank you so much!!