Why is my Filter not working for another user?

[Christopher Jones]

I've created a filter to show all issues for a specific project that has a certain custom fields flagged. 

JQL is like this: 

Project = "X" AND status not in (Closed, Cancelled) AND "Escalate?[Dropdown]" = Yes OR "Health[Dropdown]" = Red

I get the expected result.

My co-worker, however, gets a result that includes issues from other projects.

My co-worker is a project admin on project X and the filter is shared. 

It's like the project = "x" is not taken into account. Any ideas? 

[Mikael Sandberg · Accepted solution]

Hi @Christopher Jones,

Welcome to Atlassian Community!

Are you expecting to get result from just project X? The way your JQL is configured it would give you any issues in project X that are not close or cancelled and have Escalate set to yes or any issues in any project that have the health set to red. Is that what you are looking for? 

If you are only looking for result in project X then you need to use () because of the OR statement, something like this should do it:

project = "X" AND status not in (Closed, Cancelled) AND ("Escalate?[Dropdown]" = Yes OR "Health[Dropdown]" = Red)

This will give you all issues in X that are not closed or cancelled that have either escalate set to yes or health set to red.

[Christopher Jones]

Okay great, thank you @Mikael Sandberg  I will give that a shot.

You are correct we are trying to show all issues in X that are not closed or cancelled that have either escalate set to yes or health set to red. 

[Christopher Jones]

Looks to be working, thanks again @Mikael Sandberg !