JQL that will pull an Initiative with any Epic that has “Program Increment” equal to 2026-Q1

[John Pfotzer]

I am asking help writing a jql query to l findl an Initiative with any Epic that has “Program Increment” equal to 2026-Q1

Can I get some suggestions?

Thanks

John

[Chris Rogers]

Hi @John Pfotzer

Assuming that your hierarchy is Initiative -> Epic, there isn't a way to do this search natively in Jira without add-ons to my knowledge.  What you could do that would get you close is:

1. Query for epics that meet the criteria
   issuetype = Epic and "Program Increment" = 2026-Q1 order by parent asc
   
   
2. Add the parent column to the list of columns in your filter
   Configure Columns -> Filter -> Parent
   
3. Export the data to Excel/your spreadsheet program of choice, where you can filter down a unique/distinct list of initiatives.

Alternatively, you can check and see if any of the marketplace vendors have an add-on that allows subqueries (JQL Search Extensions, Enhanced Search, JQL Tricks, etc)