Selecting parent issues by matching criteria on child issues

Question

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?

Shane Hedlund · Answer

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

Petter Gonçalves · Answer

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.