Separating our JIRA Kanban Boards

[brian perkins]

I have a question on separating our JIRA Boards. Please see below.

Data Management Kanban Board

project = WFDM4 ORDER BY cf[10005] ASC
352 Issues

Data Landscape Kanban Board

project = WFDM4 AND labels in (dl_board) ORDER BY priority DESC, updated DESC
1 Issues

How can I edit the JQL for Data Management Kanban Board to separate the JIRA Kanban Boards?
Attempt:

project = WFDM4 AND labels not in (dl_board) ORDER BY priority DESC, updated DESC
259 Issues

There seem to be some missing issues in the new JQL since it is only returning 259 Issues. I would like these Kanban Boards to be completely separate.

[Guilhem Dupuy · Accepted solution]

Hello @brian perkins

My guess here would be that the missing issues are the one with no label. To include them you should add a JQL like the following one :

project = WFDM4 AND labels is not EMPTY

Let me know if it helped,

Guilhem

[brian perkins]

Yes this worked:

project = WFDM4 AND (labels not in (dl_board) OR labels is empty) ORDER BY priority DESC, updated DESC

[Guilhem Dupuy]

Nice to hear !

[Trudy Claspill]

@brian perkins 

Welcome to the community.

As Guilhem said, you are likely missing issues where the Labels field is empty.

Do you use any other values in Labels besides dl_board? If you do use other values in Labels, and you want issues with those other values or with no Labels values in your Management board, then you would need something like this:

project = WFDM4 and (labels is not empty or labels not in (dl_board))