You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
Next: Root
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 :-)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.