Jira Query by Kanban COLUMN regardless of status?

Lionel Lerner

Hey community, I'm working on a project involving tickets from many groups, so our board is comprised of tickets from many projects, with several different workflows.
I'm trying to create a Jira query that will bring me what tickets are in which column of our Kanban board.
Is there a way to create a filter based on the Kanban column instead of statuses? because we're working with a bazillion tickets and workflows and I have no way to cover all possible scenarios.

Thanks a lot and sorry if this is a repost, but I couldn't find anything specific for my need.

 

By the way this is Jira v8.5.3

Jack Brickey

Hi Lionel, welcome to the community.

I assume that you have multiple statuses in one or more of your board columns? Well you can’t write a JQL query based on kanban columns you can create filters for each column by selecting the statuses that exist in the column. 

For example...
lest say you have four statuses: to do, in dev, in QA, done. And you have them mapped to columns like this:

• ToDo: to do
• InProgress: in dev, in QA
• Done: done

then the queries for each column would be:

• ToDo- project =abc and status = “to do”
• InProgress - project = abc and status in (“in dev”, “in QA”)
• Done - project =abc and status = done