how can i get stories with their subtask where I can group by stories

madhuri September 10, 2019

I have looking for a query that will retrieve stories or task and its corresponding subtasks.

If i query only all subtask there is no coloumn showing its parent or story 

3 answers

1 vote
Ravi Sagar _Sparxsys_
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 10, 2019

Hi @madhuri 

Try filtering the parents and add a column called Sub-Tasks.

Ravi

0 votes
Warren
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 10, 2019

Hi @madhuri 

If you show the Summary column, then the parent is shown as below - 8112 is the parent for all three subtasks

Screenshot_1.jpg

 

Is this what you're after?

0 votes
Elifcan Cakmak
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 10, 2019

Hello,

If you are using script runner plugin, you can use this jql function:

issueFunction in hasSubtasks()

 You can combine it with an "And" like:

issueFunction in hasSubtasks() and issuetype = Story

Regards,

Elifcan

Suggest an answer

Log in or Sign up to answer