Subtask JQL query in nextgen projects for active and closed sprints

Question

We are unable to fetch subtasks in nextgen projects for active sprints.

Example:

project="PROJECT" AND issuetype in (subTaskIssueTypes()) gives the issues and displays the sprint as well.

Whereas the below query does not return any issues. But there are subtasks in open sprints, and these are displayed in Active Sprints board.

project="PROJECT" AND issuetype in (subTaskIssueTypes()) and Sprint in openSprints().

Subtasks are not shown when we add Sprint in JQL

Bhargav Garimella · Answer

We're using JIRA addin for Google Sheets and use a list of stories in the sprint to get the list of subtaks associated with them.

RamPrasanth.Jahadhishan · Answer

Found any solution on this issue? I am stuck with similar issue

Pitcha · Answer

I stuck with this also

I see from https://jira.atlassian.com/browse/JSWCLOUD-18461 that it's in long term backlog,

so i wonder anyone found workaround for this?