Initiatives with linked epics that contain a specific field value

[Scott Federman]

I have "Initiatives" where are connected to epics using the parent link field. There is a PI dropdown field (PI1, PI2, PI3...) in the epics.

Is the a JQL that allows me to find a list of only initiatives that are linked epics with a specific PI value?

[Mark Segall]

Hi @Scott Federman - Not without a marketplace app.  If you have scriptrunner, you could do something like this:

issueType = Initiative AND issueFunction in portfolioParentsOf("issueType = Epic AND PI = PI1")

[Scott Federman]

Hey @Mark Segall that actually mostly worked, right up to the PI part. That field is actually called "Planned PIs" and when i put that field name in the JQL without quotes around the field name,  i get

"Error in the JQL Query: Expecting operator but got 'PIs'. The valid operators are '=', '!=', '<', '>', '<=', '>=', '~', '!~', 'IN', 'NOT IN', 'IS' and 'IS NOT'. (line 1, character 30)"

and with quotes around it i get

"Error in the JQL Query: Expecting ')' or ',' but got 'Planned'. (line 1, character 106)"

[Mark Segall]

Yes quotes can totally mess with your head.  Try this instead:

issueType = Initiative AND issueFunction in portfolioParentsOf('issueType = Epic AND "Planned PIs" = PI1')

If you're still having fits, you could use the custom field ID like this:

issueType = Initiative AND issueFunction in portfolioParentsOf("issueType = Epic AND cf[xxxxx] = PI1")