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

Why is syntax for 'updated' JQL item "> -X" instead of "< X"?

mike_38fgmh

I think this works for both "updated" and "updateddate".

To determine issues "updated in the last X" you must use "> -X" ("greater than negative X ago"). Why?

Trying to use "< X" ("less than X ago") seems to utterly fail. I tried "<100d" for 100 days and was getting issues updated many years ago.

My question is not how does the syntax work, as I get it now, but why does it work this way? Why doesn't `less than` actually work?

Accepted answers

Alexey Matveev

Hello,

The point is that if you have a jql like

updated < Xd

It will give you all issues, which were updated BEFORE the currentDate + Xdays. Actually that will be all issues in your Jira instance, which were ever updated.

On the other hand if you type

updated > -Xd

means to find all issues which were update AFTER currentDate -X days and that is why it gives you only issues, which were updated from currentDate -X till now.

All comments

Alexey Matveev

Hello,

The point is that if you have a jql like

updated < Xd

It will give you all issues, which were updated BEFORE the currentDate + Xdays. Actually that will be all issues in your Jira instance, which were ever updated.

On the other hand if you type

updated > -Xd

means to find all issues which were update AFTER currentDate -X days and that is why it gives you only issues, which were updated from currentDate -X till now.

mike_38fgmh

Is this just an inherent quirk of how JQL operates?

It just doesn't seem very intuitive, like instead of 2 + 2 = 4, you have to say 2 - (-2) = -(-4), same things but one's clear and the other much less so.

Alexey Matveev

I am used to it. To be honest I do not even remeber if I had problems with it or not but the point is that you compare dates, not intervals. The updated field is a date. That is why you can wirte only date1 < date2. You can not write date1 < interval. You can not compare intervals and dates. The same in Jira. Xd is an interval, that is why Jira converts it to a date: current date + Xd. That is why you can replace Xd with currentDate + Xd in your mind. And it will be logical.

mike_38fgmh

Ah, knowing that it does make much more sense then. Still not quite intuitive if you don't already know how to type it out, but oh well. My initial issues with is is because I am usually using the Advanced search/syntax method where I type everything out, as opposed to the Basic syntax where you're selecting from dropdowns etc. At first it had completely skipped my mind to simply use the Basic syntax to create a search, then select Advanced to see how to type it out.

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-server

jql