JQL Help: Custom Sub-Tasks Not Displaying

[Dietrich]

Hi everyone! :)

I need some help with JQL please.

We are on Jira Cloud and we have ScriptRunner installed.

Our users log a custom sub-task issue type called Initiative Risk against Initiatives. Those Initiatives are in turn child issues of a custom issue type Global Initiative which exists on only one project.

I need a query that will return all the Initiative Risks that are linked to Initiatives on a specific project where the parent is a specific Global Initiative.

---

This gives me the Initiative Risks for the Initiative in question, but it's obviously not dynamic, so if new Initiatives are created it doesn't pick that up: 

parent in (EPDM-5900, EPDM-5851) AND project = "Enterprise Platform - Data Modeling" AND issuetype = "Initiative Risk"

---

I tried this too but the portfolioChildIssuesOf operator doesn't return Initiative Risk:

 issuekey in portfolioChildIssuesOf(GI-122) and issuetype = Sub-task AND status not in (Done, Cancelled) ORDER BY createdDate DESC

---

Any help would be greatly appreciated!

[Rilwan Ahmed]

Try this document: https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_subtasks