Looking for a JQL request to grab all Initiative with a feature associated

[Fabian STEL]

Hello Dears, 

I am looking for a JQL request to grab all Initiative with a feature associated

More in detail I would like a JQL request to grab all Initiatives (in a specific status) with a feature associated (in a specific status).

As exemple: 
I already used this request to grab all User stories bellow Epics. It was great !!! 
issueFunction in issuesInEpics("project = xxxx AND issuetype = Epic AND status in (Implementing)"). Now I am looking for something like this issueFunction in issuesInInnitiatives(....) or something even better to match the need

Do you have a way to do such a thing? 

Many thanks for your help 
Best Regards, Fabian  

[Trudy Claspill]

Hello @Fabian STEL 

Welcome to the community.

Based on you saying that you have the issuesInEpic function, I think you have Adaptavist Scriptrunner installed on your system. Is that true?

How have you created the Initiative issue type and linked Initiatives to Epics? Do you also have a roadmaps or portfolio app installed on your system?

[Fabian STEL]

Thanks for this warm welcome 

"Based on you saying that you have the issuesInEpic function, I think you have Adaptavist Scriptrunner installed on your system. Is that true?" 

"Do you also have a roadmaps or portfolio app installed on your system? "

--> How can I verify that ? here is what we have, I hope it answers:
"

License Information for Jira

Jira v8.13.10

The use of this product is subject to the terms of the Atlassian End User Agreement, unless other specified therein.

This product includes software developed by the Apache Software Foundation.

This product also includes the following libraries which are covered by the GNU LGPL license:

• atlassian-image-consumer (com.atlassian.image:atlassian-image-consumer:1.0.1:jar)

• carol (carol:carol:1.5.2:jar)

• carol-properties (carol:carol-properties:1.5.2:jar)

• datafile (datafile:datafile:1.3.3:jar)

• image4j (org.jclarion:image4j:0.7:jar)

• jcaptcha (com.octo.captcha:jcaptcha:2.0-alpha-1:jar)

• jcaptcha-api (com.octo.captcha:jcaptcha-api:2.0-alpha-1:jar)

• jcommon (jfree:jcommon:1.0.8:jar)

• jfreechart (jfree:jfreechart:1.0.13:jar)

• JSCalendar (1.0)

• jStyleParser (net.sf.cssbox:jstyleparser:1.16-atlassian-1:jar)

• TinyMCE-TinyMCE (4.4.0)

• xapool (xapool:xapool:1.3.1:jar)

This product also includes code written by other third parties.

Additional details regarding these and other third party code included in this product, including applicable copyright, legal and licensing notices, are available in the "licenses" directory under the Jira installation directory.

License Information for Jira Plugins

 Advanced Roadmaps for Jira v3.29.1

The use of this product is subject to the terms of the Atlassian End User Agreement, unless other specified therein.

This plugin includes software developed by the Apache Software Foundation.

This plugin includes the following libraries covered by the GNU LGPL license:

• GNU Trove(net.sf.trove4j:trove4j:3.0.3)

• JGraphT - Core(org.jgrapht:jgrapht-core:0.9.2)

• jStyleParser(net.sf.cssbox:jstyleparser:1.16-atlassian-1)

 

This plugin also includes code written by other third parties.

Additional details regarding these and other third party code included in this plugin, including applicable copyright, legal and licensing notices, are available in the "licenses" directory inside the plugin.

 Jira Agile v8.13.10

 

"How have you created the Initiative issue type and linked Initiatives to Epics?"

--> Yes

[Trudy Claspill]

You do have a roadmap/portfolio tool. That would be the Advanced Roadmaps Jira Plugin you listed. I'm assuming you used that functionality to create your Initiative issue type and link Epics to it through a Roadmap.

A Jira Administrator should be able to go to the administration screens for managing plug-ins and check if you have Adaptavist ScriptRunner. "issuesInEpics" is one of their functions, but it also might have come from another plugin.

Searching the web with phrases like

"jira query for epics in intiatives"

"jira jql child issues of initiatives"

...I found several posts on the topic. Most reference this syntax:

issuekey in childIssuesOf(<issue key for an Initiative)

I also found this in the Adaptavist Scriptrunner documentation, which would be helpful only if you have that plug in.

https://docs.adaptavist.com/sr4js/latest/features/jql-functions/included-jql-functions/portfolio