I want to see only the initiative which has epics linked(as parent) from a specific proje

[Kaushal Patel]

I want to see only the initiative which has epics linked(as parents) from a specific project.

[Stephen Wright _Elabor8_]

Hi @Kaushal Patel 

In case you're still looking to do this - can I confirm the need?

• Is it to see Initiatives which have child Epics, or Initiatives with parent Epics?
• Is the Epic which would be in a specific Project?

Could you also please confirm if you have any JQL extension Apps, like Scriptrunner? And/or if you have Automation for Jira?

Ste

[Kaushal Patel]

yeah this is still needed we only have automation for jira

want all initiatives with child epic from certain project

[Stephen Wright _Elabor8_]

Hi @Kaushal Patel 

To do this, you either need...

1. The data available on the Initiative level (i.e Has Children = Yes/No)
2. A method of sub-querying between the two hierarchical levels

Option (2) requires an App, but Option (1) might be possible using:

• A Custom Field - eg. a Checkbox field
• Automation for Jira

---

The rule might work something like this:

• If Parent Link is added to...
• Locate the Parent Issue...
• And check the Field "Has Children" to CHECKED/TRUE

And then some method to remove it again, if all children are removed.

This metadata is then on an Initiative level, and could be referred to in JQL!

---

Do you think this is workable in your instance?

Ste

[Kaushal Patel]

i am not admin and don't want to add another custom field, isn't there out of the box for this jql search for this ?

[Stephen Wright _Elabor8_]

Hi @Kaushal Patel 

Unfortunately there isn't.

The other alternative aside from Automation is to use an App which extends the functionality of JQL, like Scriptrunner - if you have an App like this, it will likely be possible to get these results.

Ste

[Kaushal Patel]

:(