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

[Randy O_Neal · Accepted solution]

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

[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...

[Trudy 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?