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; } } }

How to use date filters in JQL

simarpreet singh

Hi team,

I need to understand what does it mean by saying created>=-2h or updated <1d

Basically, I want to understand WHEN to use > and when to use <..... And when to use negative (-) and when to use positive (+) like -2d or +1d

Hope you got my needs. I know this may be a very basic question for most of you, but any help and even a documentation would be appreciated.

As a final ask, my requirement was basically to find out issues that were created between 2 am in the morning till 6 am the same day

Thanks in advance,

Simar

Accepted answers

Payne

> means after (literally the timestamp is greater, so it's later), and < means before (timestamp is smaller, so it's earlier).

Similarly, - means before, and + (or lack of sign) means after.

So, in your example of created >= -2h, that means created is after 2 hours ago, or within the last 2 hours.

Updated < 1d means updated is before 1 day from now (one day in the future), which will be all of your issues.

For your requirement, you could use this:

created >= startOfDay(2h) and created < startOfDay(6h)

startOfDay() is defined as midnight, so startOfDay(2h) means 2 hours after startOfDay(), or 2:00am. Similarly startOfDay(6h) means 6 hours after startOfDay(), or 6:00am.

Hope this helps!

All comments

Payne

> means after (literally the timestamp is greater, so it's later), and < means before (timestamp is smaller, so it's earlier).

Similarly, - means before, and + (or lack of sign) means after.

So, in your example of created >= -2h, that means created is after 2 hours ago, or within the last 2 hours.

Updated < 1d means updated is before 1 day from now (one day in the future), which will be all of your issues.

For your requirement, you could use this:

created >= startOfDay(2h) and created < startOfDay(6h)

startOfDay() is defined as midnight, so startOfDay(2h) means 2 hours after startOfDay(), or 2:00am. Similarly startOfDay(6h) means 6 hours after startOfDay(), or 6:00am.

Hope this helps!

simarpreet singh

Thanks a lot. It helps.

Constanze Schmidt

Hi Payne,

to clarify your answer: So I can either work with '>/<' or with ' -/+', that is 'created >=- 2h' or 'created <= 2h' means the same, right?

Is there a preference / recommendation on what to use?

And another question:

My query: 'duedate <= 6w' should list all issues where the due date is older than 6 weeks. But it does not work correctly: I also get issues where the due date is just 3 or 2 weeks overdue.

Would be great if you could help me with that:-)

Payne

Hi Constanze,

No, created >= -2h and created <= 2h are not interchangeable; try them both, and you'll see.

Similarly, duedate <= 6w is not correct for finding issues where the due date is older than 6 weeks; instead, you should use duedate >= -6w

-Payne

Welcome!

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

Quick Links

Find more posts tagged with

server

jira

jira-software

jira-software-server

atl-gruland