Forums

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

JQL filter for showing only open stories and their subtasks

Jessie-Kaye
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
September 20, 2019

I'm trying to create a filter to show only open stories in an active sprint and the subtasks under the stories. I have "issuetype = Story AND status not in (Done,Resolved)" which works fine, but does not show the subtasks attached to the story. When I try to 'issueFilter = subtask' I get an error. 

3 answers

1 accepted

1 vote
Answer accepted
Jessie-Kaye
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 1, 2019

Was able to solve it by making the JQL simple: 

status != Done

Jack Brickey
Community Champion
October 1, 2019

Be careful with this method. You really should be using Resolution is not empty. Resolution should always be set when transitioning to any ‘Done category status’ and cleared if ever reopened.

2 votes
Jack Brickey
Community Champion
September 21, 2019

The fact that you have declared issuetype = story will exclude sub tasks.

0 votes
Deniz Oğuz - The Starware
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.
September 22, 2019

You can use something like that if you are okey with explicitly listing story keys.

(issuetype = Story AND status not in (Done, Resolved)) OR (parent in (STORY-1, STORY-2, STORY-3, ....) AND status not in (Done, Resolved))

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events