Is it possible to see the issues in a column of a kanban board in issue navigator?

[Shailesh Kumar]

Hi,

Is it possible to see all the issues in a Kanban board column inside the issue navigator quickly? 

When I look at the Kanban backlog, I see a link called "View in Issue Navigator".  This link also doesn't seem to behave in the expected manner. 

It seems to generate a query like

     project = IPP AND issuetype in (Bug, Improvement, "New Feature", Task) and sprint is           empty ORDER BY Rank ASC

I thought it would restrict the query to only issues which are actually in backlog but that doesn't seem to be the case. 

[Jerry]

I am able to do this in one of our Kanban boards.  Each one of your Kanban columns should be associated with a 'workflow' status.  In my case the status is 'Approved for PRD Deployment'.  My JQL looks like:  project = DSPH AND status = "Approved for PRD Deployment" order by created DESC.  

This gave me everything in that particular Kanban column.

Hope this helps.

[Alexey Matveev]

Hello,

I think it does restrict issues to the backlog. I guess the "project = IPP AND issuetype in (Bug, Improvement, "New Feature", Task)" is taken from the filter, which is defined for the board. Then Jira adds " and sprint is empty", which means that only issues with empty sprint will be shown. And if an issue is not in a sprint,  then the issue is in the backlog.

It looks correct.

[Shailesh Kumar]

Unfortunately it is not. Kanban boards don't use the concept of sprints. Sprint applies only for Scrum projects. In Kanban board, the issues in backlog are identified by the issue status as configured in the backlog.

[Alexey Matveev]

Ah, that is right. You said it was a Kanban board

[Bastian Stehmann]

Hi,

Kanban Backlogs were just introduced to Jira, so this is probably an error, as this query will work for Scrum Backlogs (issues should be added to a sprint if they are not in the backlog) but not for Kanban Boards.

If you just replace the "sprint is empty"-part with "status=YOUR-BACKLOG-STATUS" you should get what you want. You can also save this query as filter, so you won't have do this again.