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.