Help with JQL query

[Jason C]

I'm trying to write a query that will show me all program epics for a specific component that are planned to start or finish in a specified date range. (In other words, my boss wants to see all work planned to start OR finish in the next quarter.)

The query I came up with looks like this:

project = ABC AND component = XYZ AND type = "Program Epic" AND "Date Planned Start" >= "2023/09/01" OR "Date Planned Finsh" <= "2024/01/01"

When I run the search, Jira returns way more than I want, to include info from other projects, components, and all types (epics, features, etc).

I thought my search criteria was pretty simple, but it's not working. Any advice?

[Jack Brickey · Accepted solution]

Try this...

project = ABC AND component = XYZ AND type = "Program Epic" AND (("Date Planned Start" >= "2023/09/01" AND Date Planned Start" <= "2023/12/31") OR ("Date Planned Finish" >= "2023/09/01" AND "Date Planned Finish" < "2024/01/01"))

I think I have it right. I am wondering if you need the "finish" bit at all though. Maybe you have work that started in say Q3 that continues to Q4 as an example.

[Jason C]

At a glance that seems to be working ... thanks!

[Jack Brickey]

Please consider accepting answer once you are confident it works.