Subtask JQL query in nextgen projects for active and closed sprints

[Bhargav Garimella]

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]

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]

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

[Pitcha]

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?