I am trying to create a filter that does not include items in the Kanban backlog. These are all in the To Do status, by default, which is the first column on my Board. I do not want these to appear in the filter results, but cannot find anything other than filtering by status, and not by those items that appear on the Board,.
To whom it may concern:
Kanban boards are functionally a filter, so you *can* get everything not in the backlog.
That is unfortunately not the case. The link you provides shows JQL that will display issues from a specific board, or from multiple board. Unfortunately there is no JQL that will all you to filter out only those issues from one board that are in the backlog. The Backlog and Board will both be in a single status (To Do for example) and there is no way to distinguish cards in a particular status that are on the Board or the in the Backlog. That functionality is not available at this time.
you may have a To Do column on the Kanban board but what status is mapped to it? It will be different that the status that is in the Backlog section of your Backlog board.
As Avinash suggested share your filter and more info about your boards status-column mapping.
Here is the filter so far:
category = "Public Cloud" AND type = Offer AND (Status = "To Do" OR Status = Expedite OR Status = "In Process" OR Status = Hold OR Status = Blocked)
The status on the card appears as To Do when I create an issue in the backlog. It is not on the board until I drag it up to it, but the backlog cards are appearing in the filter results.
Hi @Todd Heath ,
I tried below JQL and it is working for me. can you please check the same
category = "Public Cloud" AND type = Offer AND (Status = Expedite OR Status = "In Process" OR Status = Hold OR Status = Blocked)
I have To-Do status in Kanban backlog and others in board column.
That would not include the items on the board that are in the To Do column. I need to see all cards on the Board. The status in the Backlog is To Do by default, and the only options available are columns on the Kanban Board. If any column from the Board is filtered out, then I can no longer see those cards. I need to see all cards on the Board, excluding those in the Backlog. The Board and Backlog both contain the To Do status. The only solution is to be able to filter out those cards that are in the backlog, but I cannot determine how this can be done.
I don't know if this is something with the Next Gen boards, but I cannot seem to determine how to show only cards on the Board in the filter results.
I too am looking for a way to do this but have yet to find anything. We use a board that displays tickets across multiple projects and I want to filter out projects from the backlog which are in "ToDo" status but keep the items that are on the Kanban board that are in "ToDo". However there doesn't seem to be a way to do this.
Same issue here, can't find a way to exclude items from the Backlog. I went through all fields I can see in JQL, and I couldn't find any that seems to match. I had assumed there's a field somewhere that gets updated whenever we pull a ticket from the Backlog into the Board, but it doesn't seem to be the case.
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