Help with JQL query

Jason C_2mkfsd

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

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.