How to display all tasks that have subtasks that are assigned to the current user?

[PM Ievgen Chugunov]

Example:

User Story assignee - John.

Subtask 1 assignee - Peter.

Subtask 2 assignee - Anna.

Subtask 3 assignee - Elon.

Main filter:

On my active Sprint Board, I want to see only User stories, without subtasks.

project = EL AND issuetype in (Story)

Quick Filters:

On my active Sprint Board, I want to see User Story Where the assignee is Peter (Current User).

[Ollie Guan · Accepted solution]

Hi @EugenChu ,

find all parents which has sub-tasks assigned current user?

[PM Ievgen Chugunov]

Hi @Ollie Guan 

Yes, correct.

For example, I have 20 user stories on the board (Current Sprint).

In each user story, I have 10 subtasks.

The main filter is:

issuetype in (Story)

So I can see only Story on the board (Current Sprint). This is correct.

The developer wants to see only the story where the subtask

assigned to him (Current User).

So he pushes on "My Tasks" (Quick Filter) and on the board should stay only Stories where subtasks assigned to him.

[Ollie Guan]

You need script runner to extend this query.

https://community.atlassian.com/t5/Jira-questions/How-to-find-all-parents-which-has-sub-tasks-assigned-current/qaq-p/645772

https://community.atlassian.com/t5/Jira-questions/Find-parents-where-ALL-sub-tasks-meet-a-condition/qaq-p/1451653

[PM Ievgen Chugunov]

@Ollie Guan 

Thank you!)

[Trudy Claspill]

Hello @EugenChu 

Welcome to the community.

Are you working with issues in a Company Managed project or a Team Managed project? It will say which it is at the bottom of the navigation pane on the left.

When you are viewing a board, there will be an Assigned Users section showing avatars for all issues currently displayed within the board. You can click on each avatar to see the issues assigned to that user in that board.

If you want to create a quick filter that will show issues assigned to whichever user is currently viewing the board, the JQL for that would be

Assignee=currentUser()

Your post title and the last statement in your post don't match. Your post title says you want to see the Stories that have a task assigned to the current user. Your last statement says you want to see the Stories that are assigned to the current user (without regard for subtasks). Can you clarify which is the scenario you are trying to meet?

Also, is the first filter that you showed the filter for your board? Your board includes only Story issues? If that is the case, and if you truly want to add a quick filter that is based on the subtasks, you will not be successful. The Quick filters look only at the issues included in the board. If you exclude the subtasks from the board, you can use information from them in a Quick Filter for that board. 

[mauricio.groth]

Hi @EugenChu

As you're on Jira Cloud, the correct answer is to get an app that provides JQL extensions you're looking for.

With standard JQL, you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. If your use case is more dynamic than that, look beyond standard Jira.

Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service JQL Search Extensions

You can use this query to find your stories that are parent of subtasks which the assignee is Peter

issue in parentsOfSubtasksInQuery("assignee = Peter") and issuetype = Story

Check out the documentation for more examples.

If you have any other questions, please contact our support. We’ll be happy to help you!
Best regards,
Maurício