Sub-Tasks not showing up in Scrum board when filtering parent issue on custom field

[Chris Byrne]

The following filter: project in (SQC, IM, PI, ITF, CONE, DSD, LAX, DMD) ORDER BY Rank ASC will display sub-tasks,

However if I add "Assigned Squad" to the filter: project in (SQC, IM, PI, ITF, CONE, DSD, LAX, DMD) and "Assigned Squad" = Sharks ORDER BY Rank ASC. 

The "Assigned Squad" field is not present in the subtask. Do I need to add this field or is there a way to write the query so that the subtasks show up.  I tried Extended Search to include subtasks but using that we get a warning that no projects are assigned to the board. 

[Daniel Ebers]

Hi @Chris Byrne

an option I could think of is to use Automation to copy the value of "Assigned Squad" custom field to the Sub-Tasks.

Doing so, from my expectation, you filter for the custom field in your board.

From my understanding, currently, the sub-tasks do not show up as you query for the custom field which is not present in sub-tasks - as you stated.

Regards,
Daniel

[Alexander Bondarev]

Hi, @Chris Byrne !

Welcome to the Community!

Try this JQL please:

project in (SQC, IM, PI, ITF, CONE, DSD, LAX, DMD) and ("Assigned Squad" = Sharks or issuetype in subtaskIssueTypes()) ORDER BY Rank ASC

[Chris Byrne]

This added the subtasks but unfortunately also parent items in other Assigned Squads.

Thanks though

[Alexander Bondarev]

I have no ideas how to make better out-of-box…

Look at external app, for example - JQL Search Extentions 

It has useful functions like(docs):

SubtasksOfParentsInQuery

For a given JQL subquery it finds subtasks of resulting parent issues
Examples:

- issue in subtasksOfParentsInQuery("status='Done'") and status='To Do'

finds subtasks that are in progress and have finished parents

- issue in subtasksOfParentsInQuery("assignee=currentUser()")

finds subtasks of my issues