JQL Query for Scrum and Kanban Tickets who are not in Backlog

Question

Dear Community,

I have created a filter where all open tasks assigned to me are displayed from started sprints. This worked quite well with the following JQL:

status in ("In Progress", "To Do", "Selected for Development", Aufgaben, Qualitätssicherung) AND assignee in (currentUser()) AND sprint in openSprints()

Now I would like to see also the tasks in Kanban on "Selected for Development" or not on "Backlog".

The combined query shows me this now, but also the tickets of Scrum that are not in a sprint because they are still in the backlog.

status in ("In Progress", "To Do", "Selected for Development", Aufgaben, Qualitätssicherung) AND assignee in (currentUser()) AND (sprint in openSprints() AND sprint not in futureSprints() OR sprint = EMPTY)

What i try to get is a list of my Tickets that are in a openSprint and not futureSprint and not in Backlog from Scrum and also my Tickets that are not in "Backlog" in Kanban.

I have searched a lot but have not found a solution yet. Someone an idea?

Thanks a lot !

Nick Ayala · Answer

So not sure if you are still looking for an answer, but here is the query I came up with for the same type of issue.

Sprint in openSprints() OR status in ("In Progress", "To Do", "Selected for Development", Aufgaben, Qualitätssicherung) AND (assignee in (currentUser())

I usually filter by a specific project at the beginning since we usually have different boards within a project. We also have a label for each board that we put on our tasks that pertains to the specific board. so my full query looks like this

project = DEV AND (Sprint in openSprints() OR status in ("In Progress", "To Do", "Selected for Development", Aufgaben, Qualitätssicherung)) AND (assignee in (currentUser()) AND labels in (boardLabel1, boardLabel2, boardLabel3, etc)

Now you could also combine, lets say you have a label for the specific Kanban board you are wanting to query status for do this

Sprint in openSprints() OR (labels = boardLabel and status in ("In Progress", "To Do", "Selected for Development", Aufgaben, Qualitätssicherung)) AND (assignee in (currentUser())

I hope this helps.

Julian_4k0ynn · Answer

Hello Petter,

First of all thank you for the detailed answer.

Unfortunately, it did not work yet.

Point 3 would be as follows:

3 - Are in an open and active sprint or kanban board and not in a future sprint.

For example, I have two tickets that are currently in the "Selected for Development" column in a kanban board but do not appear in the filter. Only the Tickets from the scrum board are visible.

Thank you

Petter Gonçalves · Answer

Hello Julian,

Welcome to Atlassian community.

So, I understand that you would like to return the following issues in your query:

1 - Issues that are assigned to the current user that is accessing the query

2 - Are in the statuses  "In Progress", "To Do", "Selected for Development", Aufgaben, Qualitätssicherung

3 - Are in an open and active Sprint and not in a future Sprint

4 - They must not be in the backlog of your Scrum and Kanban Boards

Per the descriptions above, I believe that the parameter which might not be working in your query is the OR sprint = EMPTY. In order to return all the issues that are not in a scrum board backlog, the issues must be in an Active board.

About the kanban Backlog, there is a status that is mapped in the backlog column (Board settings > Column) of your board. It's enough that you remove the status of your query to avoid issues from the kanban board backlog to display on it.

That being said, this query should work for you:

status in ("In Progress", "To Do", "Selected for Development", Aufgaben, Qualitätssicherung) AND assignee in (currentUser()) AND (sprint in openSprints() AND sprint not in futureSprints())

P.S: Just like mentioned before, don't specify the status which is mapped to the kanban backlog column in order to avoid it from being displayed in the filter.

let me know if you have any questions.