Looking for a jql filter to list all parent tasks that the current user is assigned to child task

[John Hamman]

Hi all, I am trying to figure out the jql statement that will list parent tasks that have the current user as either an assignee or have the current user the assignee as a sub task.

Is this possible?

[Emrys]

Hi John,
I had a similar requirement but wanted for all users and used:
project = someProject AND (issuetype in subTaskIssueTypes() OR issueFunction in hasSubtasks()) ORDER BY priority DESC, updated DESC

[Prosper Agwegiokhe]

Hi @John Hamman,

My name is Prosper, a support engineer at Appfire, and I’m here to help you.

As @Samuel Gatica _ServiceRocket_ as said, unfortunately natively, you’ll not be able to do get your desired result.

In the app where my team works, JQL Search Extensions for Jira, you can use the query below to find parent tasks assigned to the current user or find tasks were a sub task is assigned to the current user:

issue in parentsOfIssuesInQuery("assignee=currentUser()")

Please contact our support if you have any other questions about this query.

We’ll be happy to help you!

Best regards,
Prosper.

[Samuel Gatica _ServiceRocket_]

Hi @John Hamman 

Welcome to the community!

Unfortunately, the desired query cannot be accomplished using native JQL.

You will need to install a third-party add-on, such as Script runner, and then you can execute the following JQL:

assignee = currentUser() AND issueFunction in parentsOf("assignee = currentUser()")

Explanation:

• assignee = currentUser(): This part of the query filters tasks where the current user is the assignee.
• issueFunction in parentsOf("assignee = currentUser()"): This part of the query finds all parent tasks that have at least one sub-task assigned to the current user.

By combining these two conditions, the query lists the parent tasks that either have the current user as the assignee or have sub-tasks where the current user is the assignee.

Hope this helps!

Best regards

Sam

[John Hamman]

Thanks Sam!

[meredith.poole]

Hi Sam! What if I wanted to be able to do this same thing, but with dynamic selection on a dashboard? Like if I wanted to select a user from a Rich Filter Controller in a Jira Dashboard, and return the parent tasks that have the user as the assignee on either the parent task or the sub task.