Selecting parent issues by matching criteria on child issues

[Shane Hedlund]

I am trying to select all parent issues by matching criteria on the child issues.

For example, I want to see a unique list of Initiatives that have Epics related to a set of customers (A `Customer` is identified on the Epic by a multi-select custom field) 

Here is what I have tried (and failed) so far:

• Type=initiative AND in epic("Customer"="Some-Customer-Name")

- This didn't work

Any ideas?

[Petter Gonçalves]

Hello Shane,

Welcome to Atlassian community!

Can you confirm for me if the "Initiative" issue type that you are talking about is the one provided by Portfolio add-on or is it just a custom issue type?

Unfortunately, JIRA does not have the functionality to run a sub-query to return parents based on sub-tasks conditions, however, there are some add-ons that might help you achieve this functionality.

Since you are using JIRA Cloud, I recommend you to try the plugin JQL Search Extensions for JIRA, which provide you with the subquery parameter that you can use to return issues which the Epic or sub-tasks match that query. So, if the initiative is a custom standard issue type, the query below should work for you:

type = initiative AND issuesFromEpicsInQuery = ""Customer"="Some-Customer-Name""

You can refer to the documentation below to know more about it:

- Subqueries - JQL Search Extensions for Jira Cloud

Let me know if this information helps.

[Shane Hedlund]

Hi Petterson, i'm confident the "initiative" issue type is the one provided by Portfolio, but how can I check this? We have installed the Portfolio plugin, so I am assuming this to be true.

Shane