How to return multiple features and their linked Parent of child issues

[Peter Read]

Good Morning: 

I am trying to figure out the JQL for returning more than one feature and all the linked child issues. The project I am working on is using features as the parent of user story and enablers. 

Here is the query I have been able to use to identify 1 feature and all linked children issues but I need to return more than just 1 feature. 

issue in linkedIssues(ABC-5668, "is parent of")

[Digvijay Singh]

Hi @Peter Read 

If you are running Scriptrunner plugin either in Data Center/ Server or Cloud then JQL Expression can resolve your issue.

You can run the below JQL Search using Scriptrunner Enhanced Search:

issueFunction in linkedIssuesOf(Subquery)

For example: First, you need to create a filter as Subquery, something like:

project = <project-name> AND issuetype = Story 

Save this filter (eg: List of Story Issues) and add this Subquery in main JQL:

issueFunction in linkedIssuesOf("filter = 'List of Story Issues'")

This will give you all the list of Feature issues - where related Stories are linked to them.

I hope this helps.

For reference: https://docs.adaptavist.com/sr4js/8.0.0/features/jql-functions

Thanks 

[Peter Read]

Yep, what I am looking for is only the issues that are direct children of the "features"? But for several features not just the one as listed originally in this query...issue in linkedIssues(ABC-5668, "is parent of")

[Trudy Claspill]

Hello @Peter Read 

Welcome to the Atlassian community.

Have you established the parent/child relationship using generic issue linking, or is it based on the Issue Type Hierarchy?

Do you want only the issues that are direct children of the "features"?

If it is based on the Issue Type Hierarchy, then you can use a JQL like this:

issue in (feature-1, feature-2, feature-3) or Parent in (feature-1, feature-2, feature-3)

[Peter Read]

Hi Trudy, thank you for responding. No unfortunately the organization does not use the hierarchy as properly should be used...

We go: 

Theme

Epic

Capability

Feature 

Story

So I am trying to run a query to pull back all stories under many different features. 

issue in (feature-1) only pulls back that feature...I need the is parent of link

[Trudy Claspill]

Hello Peter,

So, you have not modified the Issue Type Hierarchy? Located here:

https://yourJiraUrl/jira/settings/issues/issue-hierarchy

That has just three levels?

Can you provide a screen image of a Feature showing how the Story issues are displayed within that Feature?

[Peter Read]

No the client will not allow us to reduce the hierarchy, it makes daily use very challenging. 

[Peter Read]

[Trudy Claspill]

Thank you for sharing that image. It is helpful.

Your post tags say you are using the Cloud deployment and Premium plan. That would indicate you are using the Jira Cloud product (the software-as-a-service product). However, the image you shared shows the issue details layout that is presented in the Jira Data Center product. Are you aware of how to identify whether you are using the Cloud or Data Center product? I ask because that is an important distinction and impacts the answers we provide.

Do you have access to any apps on that instance that extend the JQL capabilities of Jira? Can you create filters that use the syntax?

issuefunction in ....

If so, then there may be options available through the third party apps that can help with your requirement.

If you don't have access to third party apps in your Jira instance, your options are limited to linking multiple clauses together with OR

issue in (feature-1, feature-2, feature-2) OR issue in linkedIssues(feature-1,"is child of") OR issue in linkedIssues(feature-2,"is child of") OR issue in linkedIssues(feature-3,"is child of")