nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL query on "target start" or "target end"

Karl Jackson_6d0yft

How do we create a query to return target dates outside of "now"?

The current query I have is "target end" <now() and status != done

But I want to be able to send a notification outside of the actual due date, and send it 3-5 days before the due date.

Comments

Sam Nadarajan

Hello @Karl Jackson and welcome to the Community!

There's multiple date functions that you can use, such as startOfDay(), endOfDay(), startOfMonth(), endOfMonth(), startOfWeek(), endOfWeek(), and more are available here.

If you want to query for issues that are 3-5 days before the due date, you could do something like:

due > startOfDay(-5) and due <= endOfDay(-3)
due > -5d and due <= -3d

The "-" goes back in time, so -3d is 3 days ago.

Hope this helps

Karl Jackson_6d0yft

thanks, it got me closer given I need to use "target end" this is what ultimately got me there

"target end" > startOfDay(-5) and "target end" <= endOfDay() OR "target end" < -5d and status != done

Sam Nadarajan

Awesome! If you wouldn't mind accepting this answer so that others can benefit from it in the future that would be great!

For your query, do you need to have parantheses around the last clause:

"target end" > startOfDay(-5) and "target end" <= endOfDay() OR ("target end" < -5d and status != done)

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jql

advanced-roadmaps