Initiatives with linked epics that contain a specific field value

Scott Federman March 30, 2023

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?

1 answer

0 votes
Mark Segall
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 30, 2023

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 March 30, 2023

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
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 30, 2023

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")

Suggest an answer

Log in or Sign up to answer