Searching for all subtasks assigned to me and their parent Jiras

Question

Hi all,

I'm trying to find the JQL that will allow me to search for all subtasks that are assigned to me in a particular sprint and their parent Jiras (that won't be assigned to me).

So far I have:

sprint = x and assignee = currentUser() AND parent....

The parent seems to need a parameter, but I'm not sure what the syntax would be.

Thanks!

Adam Clark_v8j3zt · Answer

Hi Jason - Thanks but this doesn't solve my problem. I actually need the parent Jira on a separate line so I can export the parent and sub tasks in a CSV

Jason Rogers · Answer

Hi,

If you are just interested in just seeing what the parent issue-key is of a Sub-Task, then it will appear in the summary of the Sub-Task when you run a search. These will appear wheather the parent issue is assigned to you or not.

So your JQL would be sprint = X AND assignee = X AND issuetypoe = Sub-task (my example below doesnt have the sprint)

In my screenshot below I also have a custom field on the far right called 'Parent Ticket ID' but this was created using a paid plugin called Customfields++

Tarun Sapra · Answer

If you feel my answer has helped, then please accept/upvote so that other users are also helped.