Looking for JSQ query to show EPICs without a certain label

[Kurt Van de Vel]

Goodafternoon,

I'm looking for a JQL query to show all my EPICs who are not tagged with a specific label.

So specifically the EPICs can have multiple labels.  (eg Label X, Label Y, Label Z etc...)

In addition to that we've asked our teams to also add 1 of 6 labels that will illustrate the nature of the epic eg:

Bugs or Defects
Customer Contractual Commit
Enabler
Run the Business
Strategic
Tech Debt or Maintenance

so for each EPIC one of the above should be present.  I'm seeking a query that will show me all the EPICs that do NOT contain any of the above 6.

Thank you.

KV

[Berat Altunhan]

Hi @Kurt Van de Vel

Can you try this JQL:

issueType = Epic AND (labels IS EMPTY OR (labels NOT IN ("Bugs or Defects", "Customer Contractual Commit", "Enabler", "Run the Business", "Strategic", "Tech Debt or Maintenance")))

[Kurt Van de Vel]

Thank you Berat,

This is my filter: 

project = DAA AND issuetype in (Epic) AND "Scrum Team[Dropdown]" in ("DAA - Aurora", "DAA - Hurricane",  "DAA - Rainbow" , "DAA - Sunrise",  "DAA - Typhoon", "DAA - Jal", "DAA - Tornado") AND "Quarterly Plan[Short text]" ~ FY24Q3 AND (labels IS EMPTY OR (labels NOT IN ("CX Auto-Bugs or Defects", "CX Auto-Customer Contractual Commit", "CX Auto-Enabler", "CX Auto-Run the Business", "CX Auto-Strategic", "CX Auto-Tech Debt or Maintenance")))

 I get below output, doesn't seem to like the spaces in the label

• The label 'CX Auto-Bugs or Defects' can't contain spaces.
• The label 'CX Auto-Customer Contractual Commit' can't contain spaces.
• The label 'CX Auto-Enabler' can't contain spaces.
• The label 'CX Auto-Run the Business' can't contain spaces.
• The label 'CX Auto-Strategic' can't contain spaces.
• The label 'CX Auto-Tech Debt or Maintenance' can't contain spaces

Kurt

[Jehan Bhathena]

@Kurt Van de Vel the error that you see if correct, Labels are not allowed to have spaces

Can you perhaps share a screen shot of the issue using such a label, and we can try to build on top of that?

[Kurt Van de Vel]

Hi Jehan, thanks for your reply.  yeah that seems to be the problem.  We had orginally added these labes in Jira Align and they propagate down to our Jira Cloud instance.

In Align, the labels are automatically appended with underscores to get rid of the spaces.

When running the same query Barat provided and using the underscores instead of the spaces  , it's all working good now.

thank you for your input both!

Kurt