Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Advanced JQL now including issues from all searched projects

Hello Community

I have the following JQL, that my team and I are using on our board, however it has come to our attention that none of the issues in Project "C" is shown/Included in the search.

(project = "A" OR project = "B OR (project = "C" AND component in (Atlassian, Confluence, Jira))) AND (labels not in (masdiverse) OR labels is EMPTY) AND (resolutiondate >= -7d OR resolution is EMPTY)

 

We've checked the issues we want to see from Project "C" have the component of either Atlassian, Confluence, or Jira.
We've checked that the issues do not have any labels, and that they do not have a resolution set.

 

Any Ideas on what could be wrong with the JQL?

2 answers

1 accepted

2 votes
Answer accepted

Hi @Casper Hjorth Christensen ,

With the JQL 

project = "C" AND component in (Atlassian, Confluence, Jira) AND (labels not in (masdiverse) OR labels is EMPTY) AND (resolutiondate >= -7d OR resolution is EMPTY)

do you get issues as a result?

 

Regards, Marco

You are right - i dont...

Removing the Labels part of the JQL gets me the results. 

Adding any form of label search removes the results.

Hi, do you get a result with only

labels not in (masdiverse) OR labels is EMPTY

?

And is 

labels != masdiverse OR labels is EMPTY 

a option?

 

Regards, Marco

@Marco Brundel 

Nope, any label search within my project "C" doesn't work. hmm could be that labels aren't used in the project, but I guess it should then fall under the "empty" variable

Hi @Casper Hjorth Christensen ,

And could this JQL be an alternative?

(Project IN (A, B) AND (labels not in (masdiverse) OR labels is EMPTY) AND (resolutiondate >= -7d OR resolution is EMPTY)) OR (project = "C" AND component in (Atlassian, Confluence, Jira))) AND (labels not in (masdiverse) OR labels is EMPTY) AND (resolutiondate >= -7d OR resolution is EMPTY)

 

 

Regards, Marco 

Hi Marco

Thanks for giving it a try, I've just tried it out, unfortunately, I get the same results/Issue count, thus still missing issues from Project C

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you