how can i filter all issues that are in the backlog in a kanban board?

[Lagger]

I have a team managed project set up as a kanban.

On the backlog tab of the space, I have the issues segmented by Board and Backlog. Essentially I want a JQL that'll give me all issues in the Backlog segment.

I'm trying to use JQL to filter all items that are not on the active board but in the backlog.

My board columns are To do, In Progress, Done. I do not have a "backlog" status.

I've tried the AI recommendation of using "status != Backlog" but that just returns everything

[Trudy Claspill · Accepted solution]

Hello @Lagger 

What you are trying to achieve is not currently possible with a filter.

It is not currently possible to filter issues in a Team Managed project to find the ones that are not on an active Kanban board (only in the Backlog). There is not native field currently available in the issue that indicates if it is in the Backlog or on a Board, and being on the Board is not based on the status of the issue.

Can you tell us about your use case and the problem you are trying to solve by creating this filter? Perhaps we can suggest an alternative.

[Lagger]

1. Simply just doing an export to csv

2. Investigating a Discord integration, of which only the board tickets would be relevant. Currently all tickets are being spammed and is noise.

[Trudy Claspill]

I'll keep pondering, but I'm not sure if there is an alternate method, like an API, to get what you want.

I did find a change request on this topic, to which you can add your vote:

https://jira.atlassian.com/browse/JSWCLOUD-17786

[Shalini Pradhan]

Hello @Lagger ,

Good day! Welcome to Atlassian Community :)

In a team-managed project, the Backlog section is not a status and it is not a separate field. In a Team-managed Project, all issues created(except from the board)are placed in the Backlog of the board by default.

In order to view the workitems, you will have to manually navigate to the backlog and check which work items are present under Backlog tab. There is no JQL concept here.

Also, you will have to move the required issues from the Backlog to the Board section of the Kanban board manually by dragging to be able to visualize them on the Board.

Some reference FRs:

https://jira.atlassian.com/browse/JSWCLOUD-17786

https://jira.atlassian.com/browse/JRACLOUD-85649

Thank you

[Lagger]

Thanks. As a workaround, is there a jira automation trigger for when an issue moves in/out of the board? The workaround I'm thinking is creating a label and adding/removing based on board <-> backlog movement.

[Trudy Claspill]

Hello @Lagger 

No such automation trigger currently exists.