Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

J.M.
Contributor
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.
Contributor
July 23, 2018

Never saw that syntax! Thanks!

Like • Ignacio Pulgar likes this
Dave F
Contributor
September 6, 2021

If you have many different sub-task issuetypes then 

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

Like • 2 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-
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 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.
Contributor
July 18, 2018

I want to hide sub-tasks in to do

Suggest an answer

Log in or Sign up to answer