Quick Filter for Kanban Board to hide only sub-tasks with specific status

J.M. July 18, 2018

I'm trying to create a filter that hides sub-task issue type in the status of "To Do" but every JQL I can come up with also is hiding all other issue types in "To Do." Whats the JQL trick I'm missing?

example:

(issuetype not in (Sub-task) and Status not in ("To Do"))

3 answers

1 accepted

2 votes
Answer accepted
Ignacio Pulgar
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 20, 2018

!(type = sub-task AND status = "To Do")

J.M. July 23, 2018

Never saw that syntax! Thanks!

Like Ignacio Pulgar likes this
Dave F September 6, 2021

If you have many different sub-task issuetypes then 

!(type not in (subTaskIssueTypes()) AND status = "To Do")

Like # people like this
0 votes
B. TORRES April 20, 2020

This should be as easy as:

  1. Go to your Project
  2. Open Board settings
  3. Click  Edit Filter Query
  4. Filter by checking all Issue Type except Sub-task
  5. Click Save
0 votes
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 18, 2018

It's about logic, not trickery.

For an issue to appear with that query, it must be not a subtask AND not in to-do.  The clauses combine to select all issue types when you are asking about the status.  I suspect what you want is

issuetype not in (subtask) or (issuetype in (subtask) and status = "to do")

J.M. July 18, 2018

I want to hide sub-tasks in to do

Suggest an answer

Log in or Sign up to answer