nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Query to return parent issues of specific epics

Szymon F

Hi, I am using Jira Cloud + Plans + Scriptrunner and struggling with a query that returns parents of epics. Here is my example:

Initiative-123

Epic-234
Epic-345 (Planned = YES)

Initiative-987

Epic-456
Epic-567 (Planned = YES)

I was trying hard to write a query based on the custom field 'Planned' on the epic returns all initiatives.

Here are my tries that do not return anything:

<span>issue</span><span>type</span><span> = </span><span>Initiative</span> <span>AND&nbsp;issueFunction in linkedIssuesOf("Planned = 'YES'", "is Epic of")&nbsp;</span>

issueFunction in parentsOf(...)

If you have any ideas, please let me know

Accepted answers

Szymon F

I got the answer from Adaptavist - it is not possible to achieve it on the Jira Cloud due to API limitations, but it works in Jira Server. However, there is a feature request that you can all vote to make it happen:

https://scriptrunner-for-jira-cloud.nolt.io/47

All comments

Ditte Simard

You should be on the right track with the "parentsOf" function. Since the Initiatives are parents of the Epics, try something like this:

issueFunction in parentsOf("issuetype = Epic AND 'planned' = "YES")

Szymon F

That is the thing, it does not work. I even tried to use

issueFunction in parentsOf("key = Epic-345")

with 0 results.

Given that I believe it should work and you confirmed my thinking there is one more issue that can cause this problem:

https://community.atlassian.com/t5/Jira-Software-questions/JQL-for-certain-Epic-parents/qaq-p/2253117

Adaptavist support suggests that a likely cause is a conflict in function names between multiple Jira add-ons

It was posted for Jira Server but I guess a similar issue might be applicable to Jira Cloud. In the meantime I will reach out to the Adaptavist support

Venugopala Naidu

@Szymon F If you are in Jira software premium plan please try to search child epics of initiatives rather than try searching parents of epics by using the below query:

issuekey in portfolioChildIssuesOf("Initiative Key") AND type in (Epic)

issuekey in portfolioChildIssuesOf("ABC-123") AND type in (Epic)

Szymon F

This will not give me the results that I need. The CF is on the epic but I am interested in the Initiative list.

Anyway, thank you for your suggestion!

Szymon F

https://scriptrunner-for-jira-cloud.nolt.io/47

Ditte Simard

I will definitely vote for that request! Thank you for posting what you found out.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud