Query for a date range

[Christina Le]

I am trying to pull a list of tickets that have a start date between August 26th and August 31st, but keep getting tickets in a different range.  Is there a way to show tickets that have a start date on the week of 8/26? 

issuekey = Ticket-782 OR "Parent Link" = Ticket-782 OR issuekey in childIssuesOf(Ticket-782) AND "Target start" = "2024-08-26"

[Trudy Claspill]

Hello @Christina Le 

Welcome to the Atlassian community.

When you use OR in your filter that tells Jira you want issues that match any of the OR'd conditions. Your filter is being interpreted to find issues that match any one of this set of conditions:

1. issuekey=Ticket-782
2. "Parent Link"=Ticket-782
3. issuekey in childIssuesOf(Ticket-782) AND "Target start" = "2024-08-26"

The date criteria is applied only to the issues that are selected by the issuekey in childIssuesOf(Ticket-782) criteria. Is that what you intended?

Additionally this criteria:

"Target start" = "2024-08-26"

...will get the issues that have exactly that value in the "Target start" field. If you want issues where the "Target start" is within a date range then you need criteria like this:

"Target start" >= "2024-08-26" AND "Target start" <= "2024-08-31"