Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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
Community showcase
Published in Jira Service Management

JSM June Challenge #2: Share how your business teams became ITSM rockstars

For JSM June Challenge #2, share how your non-technical teams like HR, legal, marketing, finance, and beyond started using Jira Service Management! Tell us: Did they ask to start using it or...

322 views 9 7
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you