nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL not returning expected results

Michele Bazzani

As stated above. We have created a separate Training KanBan board for one of our teams. The criteria for that board is based on a label. That JQL Filter is working well, but when I modified the JQL for the main board from Project = 'Business Intelligence'

The JQL is: Project = 'Business Intelligence' and labels != Training

When I run the query we lose 53 records from the board, of which 51 are done, 1 has a training label and the other does not.

I am unsure why the ticket with no label is being removed from the KanBan board. The only distinctive feature of the missing ticket is that it is a Bug.

Can someone let me know what I am doing incorrectly?

Thanks
-M

Accepted answers

Randy O'Neal

Try project = "Business Intelligence" AND (Labels is EMPTY OR Labels != Training)

All comments

Randy O'Neal

Try project = "Business Intelligence" AND (Labels is EMPTY OR Labels != Training)

Trudy P Claspill

When you use a criteria like

labels != Training

...there must be a value in the Labels field against which Jira can compare the value you have specified. If the field has no value, the comparison cannot be done and the issue with no value will be excluded from the results.

To be clear you started by using this filter?

labels != Training

And then you changed it to this?

Project = 'Business Intelligence' and labels != Training

And just adding the project criteria resulted in 53 issues being removed from the kanban board? And before the filter was updated those 53 issues displayed on the board?

Are those 53 issue in projects other than the Business Intelligence project?

Michele Bazzani

That's what worked! Thank you! I knew in the back of my just-returned-from-vacation brain that there was something I was missing about that field

Thank you!!

Randy O'Neal

Most welcome! I'm glad it fixed your situation. The first time I encountered this it left me scratching my head for a while. Glad to pass on some useful intel...

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud