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:

issuetype = Initiative AND issueFunction in linkedIssuesOf("Planned = 'YES'", "is Epic of") 

issueFunction in parentsOf(...)

If you have any ideas, please let me know

[Szymon F · Accepted solution]

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 

[Ditte Simard]

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

[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!