Advanced JQL Search, Filter by Board Column

[Thomas Radford]

Hello JIRA community,

I am configuring an advanced search using JQL, and I want to exclude tasks that are in the column named 'Backlog' on my project board. I have had a look through the search field reference, but I cannot find anything relating to the 'column'.

https://confluence.atlassian.com/jirasoftwarecloud/advanced-searching-fields-reference-764478339.html

Can someone tell me which filter field I need?

Thanks,

Tom.

[Jack Brickey · Accepted solution]

Hi Thomas! You need to determine the status(es) that make up the backlog. You can do this via board settings > columns. Once you know this your JQL would include

AND status not in (a,b,...)

where a, b,... represents the status(es) in the column.

[Thomas Radford]

Thank you. I did not realise that the board columns matched the task status.