Get a list of tasks/subtasks from epics in the current sprint

[Paulo Santos]

Hi Jira Community,

I'm trying to gather a list of tasks/subtasks that are in an active sprint, where themselves or their parent contains a specific label.

Example, with this following JQL i can get the full list of items im looking for (independently of the sprint):

labels = my-label OR issueFunction in issuesInEpics("labels = my-label") OR issueFunction in subtasksOf("labels = my-label") ORDER BY priority DESC

When i try to do the same but cross checking it with an active sprint i only get results (tasks under an epic) when the epic itself is on the active sprint else i get nothing

labels = my-label AND Sprint in openSprints() OR issueFunction in issuesInEpics("labels = my-label AND Sprint in openSprints()") OR issueFunction in subtasksOf("labels = my-label AND Sprint in openSprints()") ORDER BY priority DESC

I'm trying to get a list of all items containing 'my-label' or when their parent contains that specific label even if not on the active sprint (but their childs are)

Epic 1 with my-label not in an active sprint

Task 1 belongs to Epic 1, does not have my-label but its on the active sprint

Is it possible to do something like this ? 

Thank you!