JQL date filtering

Jawad Zakhour November 27, 2020

I have a specific date which I want to retrieve all the issues from

"jql":"(assignee in membersOf('IT Users') OR assignee in membersOf('letbot1') OR assignee in membersOf('Software Engineering')) AND created >= 2020-11-26 AND created < 2020-11-27 OR updated >= 2020-11-26 AND updated < 2020-11-27  ORDER BY created DESC",

 

I want to get the issues created only on the 2020-11-26 but with this filter I still get issues from 2020-11-27.

Thank you

1 answer

1 accepted

0 votes
Answer accepted
Jens November 27, 2020

It is really strange, I used it the same way and it shows only tickets created on 2020-11-26.. The syntax "created >= 2020-11-26 AND created < 2020-11-27" should work for the only date.

Jawad Zakhour November 27, 2020

I have updated my jql quey

I want only the issues created OR updated at 2020-11-26

the API returns issues from 2020-11-27

Jens December 1, 2020

Try this:

((assignee in membersOf(IT) OR assignee in membersOf(IT) OR assignee in membersOf(HR)) AND (created >= 2020-11-26 AND created < 2020-11-27)) OR ((assignee in membersOf(IT) OR assignee in membersOf(IT) OR assignee in membersOf(HR)) AND (updated >= 2020-11-26 AND updated < 2020-11-27))

(Just fill in your Groups name :-) )

It shows issues which were created on 2020-11-26 (and now might have different Updated date) OR issues that were updated on 2020-11-26 (but obviously might be created before with another Created date)

Another case would be, if you need only issues created OR updated on 2020-11-26, so you need only this date in both Created and Updated date, so it would be like this:

((assignee in membersOf(IT) OR assignee in membersOf(IT) OR assignee in membersOf(HR)) AND (created >= 2020-11-26 AND created < 2020-11-27) AND updated >= 2020-11-26 AND updated < 2020-11-27) ORDER BY created DESC

The tricky thing is that the description is created OR updated 2020-11-26, but you must use operator AND because you need both dates to be the same ;-)

I hope I understood it well :-)

Jawad Zakhour December 1, 2020

Yes exactly I should replace the OR with AND so I get the only date I'm looking for.

Which is created or updated on 2020-11-26.

So I want them to be created and updated on this date.


thank you.

Jawad Zakhour December 1, 2020

But doesn't the AND operator return the issues created AND updated on 2020-11-26?
Meaning created and updated only on 2020-11-26

If there is an issue created on let's say 2020-11-22 but it got updated on 2020-11-26.

I won't get that issue returned although I need it.

right?

Jens December 1, 2020

I hope I'm not getting to much confused :-) Yes, you are right, if you need to see issue created on 2020-11-20 but updated on 2020-11-26, you should use the first query I posted.

Jawad Zakhour December 1, 2020

Sorry for the confusion if I caused any.

But the first query also wont work as I need it to.
It returns updated dates > 2020-11-27 such as 28 and 29.

The thing is that I need the issues created on 2020-11-26 or updated on 2020-11-26

for example:

if an issues is created 2020-09-22, but it got updated on 2020-11-26 I need it returned.

That's it basically.
I hope I explained well this time.

Sorry again for the confusion.

Jens December 1, 2020

OK, so it should be like issues created on 2020-11-26 OR updated on 2020-11-26 but not updated later ? So in the results there will be issue created on 2020-09-22 and updated 2020-11-26 but not issue created on 2020-11-26 and updated on 2020-11-28. Am I right ?

Jawad Zakhour December 1, 2020

Yes, but the thing is if its created and has no update then I want the created only on 2020-11-26. meaning only in the case where the issue got updated on 2020-11-26 i take it even if the date is before.
But yes I think you got my idea (so it should be like issues created on 2020-11-26 OR updated on 2020-11-26 but not updated later).

Daniel Ebers
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 5, 2020

If I understand you right this would effectively require a condition within JQL query which is not available - at least not right out of the box.

Because of the logic of its the OR -operator will also show issues (which is not desired) that were updated past 2020-11-26 *as long as* the creation date is: 2020-11-26.

To summarize what was understand:

An issue should be returned when created on 2020-11-26 (with or without further updates during 2020-11-26).

An issue should be returned when created on 2020-11-22 and updated on 2020-11-26.

An issue should not be returned when created on 2020-11-22 and updated on 2020-11-28.

An issue should not be returned when created on 2020-11-26 when updated on 2020-11-28.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events