Searching for all subtasks assigned to me and their parent Jiras

[Adam Clark]

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! 

[Tarun Sapra]

Hello @Adam Clark 

I don't think you can do it using the default JQL functions, but using plugins it's possible to write such JQL.

If you have the paid plugin script runner then it's quite easy to get the results

 issueFunction in parentsOf("assignee = currentUser()") and sprint = x and assignee != currentUser()

The above query gives you all issues in a sprint(x) which you are *Not* assignee to but the issues have sub-tasks which you *Are* assigned to 

[Tarun Sapra]

https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_parentsof

[Adam Clark]

Thanks Tarun - unfortunately I think it'll be unlikely that i'll be able to get a plugin installed, but at least I know it's not possible. 

[Tarun Sapra]

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

[Jason Rogers]

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++ 

[Adam Clark]

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