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 · Accepted solution]

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

[Lionel Lerner]

Thanks, I suspected as much. We're talking about one of the largest Jira environments here, so I can't possibly guess which statuses will I face, I guess I'll have to change my query everytime I come across a new status. Thanks!