JQL nested for parent functions

[Hari Shankar Gadamsetty]

This is our JQL and I want the associated Stories & Subtask also to be filtered and showcased in the filters but as of now this is showing only epics, as we are in Jira cloud and we don't have script runner plugin and we don't have access to issuesinepic function
project = XXXX
AND type IN (Epic)
AND "aspired quarter of release[select list (cascading)]" IN cascadeOption(10061, 10067)

[Trudy Claspill]

Hello @Hari Shankar Gadamsetty 

Welcome to the Atlassian community.

If you have only native JQL functionality available you cannot get what you want. Natively Jira does not support nesting filters; i.e. getting children of Epics where those Epics are determined dynamically through a filter.

You can use 

Parent in (<comma separated list of Epic keys>)

...but you must explicitly list the Epic keys.

To get nested filtering capabilities within the UI in JQL requires a third party app.

[Trudy Claspill]

Hello @Hari Shankar Gadamsetty 

Did you find a solution to your requirement?

[Thiago Wenceslau -Appfire-]

Hi  @Hari Shankar Gadamsetty

I’m Thiago, a support engineer at Appfire.

If you are considering using third-party apps, the Jira Search Extension (JQLSE) would be the fit for your needs.

With JQLSE, you can filter epics children through the function childrenOfIssuesInQuery(). Below is an example of query based on what you’ve shared:

project = XXXX

AND type IN (Epic)

AND "aspired quarter of release[select list (cascading)]" IN cascadeOption(10061, 10067)

OR

issue in childrenOfIssuesInQuery("project = 'XXXX' AND type IN (Epic) AND "aspired quarter of release[select list (cascading)]" IN cascadeOption(10061, 10067)") AND issuetype IN ("Story", "Sub-task")

 
This way, you can show both epics and their children, according to the issuetype selected, as shown at the end of the query.

Remember to set the conditions accordingly to your needs.

Please contact our support if you have any other questions about this.

Best regards, Appfire support team.