Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,467,374
Community Members
 
Community Events
177
Community Groups

JQL date filtering

Edited

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

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.

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

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 :-)

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.

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?

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.

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.

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 ?

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 Community Leader Dec 05, 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

Atlassian Community Events