Show me all epics ("feature"), related to a specific portfolio epic, which have subtask & label

[Kha, Der Huei (AS - Allianz Suisse Gruppe)]

Hi all

I am currently working on querry to show a functional role related features & subtasks to review:

(A)

1. Show all related features (technically epic) related to a specific portfolio epic (technically also epic),

2. which contains a specific label within the subtask.

We have come up with the following JQL:

project = "Product & Underwriting Retail (Program Level)" AND issueFunction in linkedIssuesOf("issuekey = LPM-211") AND issueFunction in subtasksOf("labels = privat-dpo") --> Unfortunalty this querry did not show any hits - although examples are existing.

(B)  Same on story level

1. Show all related stories related to a specific feature (technically epic),

2. which contains a specific label within the subtask.

Thanks for your support.

[Danut M [StonikByte]]

Hi @Kha, Der Huei (AS - Allianz Suisse Gruppe) ,

Our Great Gadgets plugin could be helpful here. It offers a Work Breakdown Structure (WBS) gadget that takes the issues from a specified filter and displays them in a tree structure, by their hierarchy, in form of Initiatives (portfolio epic) > Epics > Stories, Tasks > Sub-tasks, exactly as you want.

All you have to do it to have a filter that returns the issues to be grouped and to configure the gadget to use this filter. Then, the magic will happen.   

Please note that this app offers many other gadgets that you will find useful. Just have a look over the articles from our blog to make an idea. It can be a great asset for your team and company.

I hope this helps. 

Thank you,

Danut 

[Hannes Obweger - JXL for Jira]

Hi @Kha, Der Huei (AS - Allianz Suisse Gruppe)

welcome to the community.

The "issueFunction in something" syntax comes isn't native to Jira, but comes with the ScriptRunner app. I'm not an expert myself, but from reading through your requirements, I feel you may have to use parentsOf instead of subtasksOf?

On a more general note, when debugging a JQL statement, I always like executing the different parts of the statement to see if they make sense in themselves, and only if the parts make sense, combine them with AND or OR. In your case, I'd check

• issueFunction in linkedIssuesOf("issuekey = LPM-211") - is this returning the expected results?
• issueFunction in parentsOf("labels = privat-dpo") - is this returning the expected results?
• If both return the expected results, then <query-a> AND <query-b> will be the intersection of these two results.

Hope this helps,

Best,

Hannes

[Hannes Obweger - JXL for Jira]

... and just to put this out there: As you seem to often deal with hierarchies of Jira issues, you may want to consider one of the more hierarchy-focused apps from the Atlassian Marketplace. These apps typically have their own ways of figuring out parent/child relationships between issues, and provide more powerful ways of visualising and searching through issue hierarchies. E.g., I myself work on such an app, in which both your use cases would be easy to solve, JXL for Jira:

This is how use case B could look in action:

Put simply, you'd create a sheet with all issues that are potentially relevant to you, enable the default issue hierarchy (that's just one click) or model your custom hierarchy (e.g., based on issue links; that's just a couple of clicks), and then use JXL filtering capabilities to narrow down to the issues that you care about.

Once you have your list of issues, you can work on these directly in JXL (much like you'd do in e.g. Excel or Google Sheets), trigger various operations in Jira, or export them for further processing.

Any questions just let me know!