Is is possible to query any tickets in an EPIC that have a completion date within a time period?

Question

So for example; any tickets in a "Support 2022 EPIC" that had a preface of "Microservices" from Jan 1 to Dec 31? Thanks.

Mark Segall · Answer

Hi @emma.dube1 and welcome to the community!

You could do something like this:

"Epic Link" = ABC-123 AND summary ~ "Microservices" AND resolved >= "2022-01-01" and resolved < "2023-01-01"

Clark Everson · Answer

Hi @emma.dube1

Welcome to community! It is possible to use specific dates within JQL you just need to make sure to format the dates correct i.e.

createdDate >= "2017-11-16 14:00" and createdDate <= "2017-11-16 23:00"

The JQL operators page is probably the best resource:

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-operators/

Best,
Clark