JQL date filtering

[Jawad Zakhour]

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

[Jan Jeník · Accepted solution]

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]

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

[Jan Jeník]

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]

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]

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?

[Jan Jeník]

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]

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.

[Jan Jeník]

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]

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]

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.