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