When using multiple organizations in a filter my results are not correct. Why is this?

[Calvin]

I am working to create some filters for some of our larger customers that have multiple organizations that use JSM but do not live under one organization. When I filter down to project, status and one organization the filter works, when I filter down to project, status, and multiple organizations using Project = Project and Status = Bug on Hold and Organization = XXX or Organization = YYY.... etc for up to 15 organizations the filter, when the JQL is run it filters down to the organizations correctly but the statuses will include all statuses.

Any insights to why the organizations wrecks the filter?

[Trudy Claspill · Accepted solution]

Hello @Calvin 

Welcome to the Atlassian community.

Instead of 

Organization = XXX or Organization = YYY

try using

Organization in (XXX, YYY)

When you combine ANDs and ORs in your JQL there is a precedence to the evaluation. What you are getting is all issue that match you project, status, and first Organization criteria, and then all issues that match your second Organization criteria disregarding your project and status criteria, and then all issues that match your third Organization criteria disregarding your project and status criteria, and so on.

[Joseph Chung Yin · Accepted solution]

@Calvin -

Welcome to the community.  You should correct your JQL to -  project = xxxxxx and status = xxxxx and organization in (xxxxxx, yyyyy etc...)

If you want to see all statuses of issues, then you need to remove the status criteria out from your JQL.

Hope this helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Technology Applications Team

Viasat Inc.

[Esteban Diaz]

Hi @Calvin 

You need to use parenthesis in your query ... like this:

project x AND status = done AND (Organizations = "ORG1" or Organizations = "ORG2")

 or you can use the clause IN like this:

project x AND status = done AND Organizations IN( "ORG1" ,"ORG2", "ORG3")

I hope this has been useful to you.
I will be waiting for your comments. 😉

Cheers!

Esteban Diaz
https://www.linkedin.com/in/estebandiaz/