JIRA query filter needed to retrieve all the stories from capability

Harihara Prasath V

Dear All,

I have the following scenario:

The following query retrieves multiple Capabilities in the project

project = XXXX AND issuetype in (Capability)AND PROGRAM INCREMENT = XXXX

The above query retrieves all the Capabilities from the project XXXX.  (For example, 2 Capabilities retrieved)

 

I want all the total stories under these capabilities(It means, I want to retrieve all the stories under the epics of these capabilities.).

 

project = XXXX and issueFunction in linkedIssuesOf("issuetype = capability and PROGRAM INCREMENT = XXXX", "is parent of") and issuetype = Epic

 

The above query retrieves all the epics.(For example 10 Epics retrieved)

 

Now, I want to retrieve all the stories from the above 10 Epics.  This is my request.

Thanks in advance for your support.

Regards,
Harihara Prasath.

Kalyan Sattaluri_iinm1n

Hello @Harihara Prasath V 

You need to chain another function to get your issues under your epic like below.

Please try:

issueFunction in issuesInEpics("(project = XXXX and issueFunction in linkedIssuesOf('issuetype = capability and PROGRAM INCREMENT = XXXX', 'is parent of')
and issuetype = Epic")

 

If you run into syntax errors, you can save your Epics JQL as filter and refer to that to get your stories like below:

issueFunction in issuesInEpics("filter=12344")

 

Finally, please review below list to understand how to do multiple nested issuefunction syntax,

https://community.atlassian.com/t5/Jira-Software-questions/Proper-syntax-for-doing-quadruple-nested-issueFunction-JQL/qaq-p/1647631

Please let us know if issues, hope it helps.