I'll soon be migrating one project to another, to clean up the amount of projects we have in our current JIRA setup.
The project everything gets migrated to, already has a few boards, based on a filter that looks like this:
project = ASWR AND "IRD - Dev Team[Select List (multiple choices)]" = Polaris
There are two teams using the same backlog but only see their assigned tickets on their own boards with this filter. The migrated tickets will not have a dedicated team assigned, but can be identified by the labels field.
So my assumption was that adding the additional filter portion below to the already existing filter, would exclude these tickets.
AND labels != "java-service-upgrade"
Since the original board filter returned 557 tickets, and there are no tickets yet with a 'java-service-upgrade' label in the project, that the amount of returned tickets remained the same.
The result however was a drop in returned tickets to 335 tickets. Which of course was unexpected, at least for me.
After tinkering with the setup, I managed to get the desired result
project = ASWR AND "IRD - Dev Team[Select List (multiple choices)]" = Polaris AND (labels != "java-service-upgrade" OR labels is EMPTY) ORDER BY Rank ASC
It seems that the tickets without a label, also got excluded when I added the not. So I have it working for our purposes, but wonder why tickets with an EMPTY labels field were also excluded.
It's a logically correct, but very counter-intuitive thing for us humans. We're a bit more clever than computers and make helpful logical deductions automatically which save time, but are not strictly correct.
This is a bit easier to show as an example and some careful phrasing: Let's say you have three issues, labelled as:
We ask the question "does this issue have a label called 'green'"?:
Logical (computer) replies:
When you ask the question "is empty", the computer can now answer yes or no because you're deliberately asking for "no list there", which it can answer!
Totally counter-intuitive, but worth bearing in mind when querying list data, until Atlassian make it intuitive (if ever)
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