Forums

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

How do I build my JQL to return count of parent and subtasks?

Angela Boston
Community Champion
June 1, 2018

I'm fairly certain JQL does not automatically return counts of subtasks in a query because when I exclude subtasks in a query I get the same count as when I did not.  How do I construct the JQL to return the count of Parent and Subtasks? 

Example: project=ABC and issuetype=Defect and status!=Closed

-My count is 10 (and the list, of course)

-I know there is a sum of 5 subtasks across the 10 

I would like to see 15 and the detail.

Or maybe this has been answered elsewhere? 

1 answer

1 accepted

1 vote
Answer accepted
Bryan Trummer - ReleaseTEAM
Community Champion
June 1, 2018

Hi Angela,

You will want to include the issuetype of subtask in your JQL so they are included. The following JQL should return 15 items as long as those subtasks do not equal Closed.

 

project=ABC and issuetype in (Bug, Sub-task) and status!=Closed

Angela Boston
Community Champion
June 1, 2018

Ah, ok.  Explicit.  So simple.  Thank you. 

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events