Scrumboard Filter issuetype = subtask AND parent assigne = CurrentUser()

[Ru Ch]

Hi guys,

here is my scenario:
I have a scrumboard (active sprints) for my team and we have a HomeOffice time for now. I would like to have a filter per person on my daily.

assignee = <USER> or assignee is EMPTY

But this shows also Stories and BacklogItems that are totally unrelated to the USER.

I search for something like this:

assigne = <USER> or issuetype = subtask AND parent assigne = <USER>

this would only show user assigned items and the subtasks of their assigned items even if they are unassigned or assigned to another user!

Is this possible?

Jira v8.5.5

best regards

[Ste Wright]

Hi @Ru Ch 

Just to confirm, you're looking for:

• All standard issues where the user is the Assignee
• All sub-tasks of those issues (regardless of Assignee)
• All sub-tasks where they're the Assignee (but possibly not the parent)?

Some of these queries are possible - but altogether, you'll need an app which extends the functionality of JQL to allow for sub-queries into other issue type levels - for example, Scriptrunner.

You could then search (for example):

assignee = currentUser() OR issueFunction in subtasksOf("assignee = currentUser()")

^ The first step located issues where the user is an assignee - either standard or sub-task level issue types.

The second, bold part looks for issues which are sub-tasks of any issue where the user is the assignee - in effect, this is the "parent assignee" you were attempting in your original question.

You could refine the search if you wanted to restrict it to just standard issue types assigned to the user - and all their sub-tasks - for example:

assignee = currentUser() AND issuetype in standardIssueTypes() OR issueFunction in subtasksOf("assignee = currentUser() AND issuetype in standardIssueTypes()")

Let us know if you have any questions :)

Ste

[Ru Ch]

This is exactly what I was searching for. Okay have to crosscheck if it would be possible for us to enable such an Scriptrunner.

Thank you for your feedback.

[Ste Wright]

Hi @Ru Ch 

Awesome! Let us know how it goes! Or if you get a different JQL extension app and need assistance with the query, let us know :)

Ste