Trying to get a list off subtasks with a specific label in it for items in current open sprints

[Adam Glover-Meade]

Im trying to get a list of subtasks the have a specific label (in this case "ConfigChange") but i only want to see this list where the subtask parent bug/story is in any current open sprint.  Ive tried AI and web resources and keep getting blocked my not quite right JQL.  is this even possible?
a couple samples i have tried 

• issuetype = Sub-task AND labels = ConfigChange AND parent in (sprint in openSprints() AND issuetype in (Story, Task, Bug, Epic))
• issuetype in subtasks() AND labels = ConfigChange AND issueFunction in parentsOf("sprint in openSprints()")

I also tried creating a subfilter to use and that didnt work either.  

issuetype = Sub-task AND labels = ConfigChange AND parent in filter("ParentTasksInOpenSprints")

It doesnt seem to like the "filter" query in the commands.  any ideas?

[Dmitry Astapkovich _Colined_]

As far as know, sub-task don't carry any info about the sprints. Therefore you need to search for parent issues in the sprints first, extend the result to child issues and then filter out initial parents. This is not doable in Jira out-of-box unfortunately. 

If you are ok to use 3rd party apps, you can take a look in Pivot Report we develop. It allows you to extend initial search results with related issues (both parent and child ones) and create custom slices. You can check demo report here or take a look on the screenshots below:

Alternatively, you can just click on a cell with sub-task to get the breakdown in a popup:

[Karan Sachdev]

Hey @Adam Glover-Meade

The subtasks inherit the Sprint from the parent issue. So you can search for the subtask directly (If a parent is in open sprint, the subtask will also be in active sprint).

Issuetype = subtask and labels = ConfigChange and sprint in openSprints()

Thanks!

[Adam Glover-Meade]

I have tried this and i get no results, even though i know there are two subtasks in this scenario.  from what i read, it seems like subtasks inherit the sprint, but it is not explicit on the issue type,  so none of mine have an explicit sprint of current sprint

[Adam Glover-Meade]

also if i do this i can see the records, but as soon as i add the parent logic. they disappear - 

I see the issue - issuetype in subTaskIssueTypes() AND labels = ConfigChange

I dont see the issue - 

issuetype in subTaskIssueTypes() AND labels = ConfigChange AND parent in openSprints() 

[Karan Sachdev]

Hey @Adam Glover-Meade

Are you using a Team-managed project? If so, there's a bug that results in incorrect results when subtasks are filtered by sprints: https://jira.atlassian.com/browse/JRACLOUD-90898

Thanks!

[Adam Glover-Meade]

No, im using a company managed project.  as soon as i put in the open sprint parameter the list goes blank.  

[Karan Sachdev]

Can you please try with the sprint and issue type condition only?

Issuetype = subtask and sprint in openSprints()

I'm suspecting the subtasks don't contain this label, hence no results.

Thanks!