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

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 Query WorklogDate (Operators) decide the value of time.

Hey Atlassian Community & Team, 

Just wanted to mention that the operators like > or < are the deciding factor for the time value consideration in jql query.

Eg:- worklogDate >= "2021/07/13"

This will consider the time value as - "2021/07/13 00:00"

2. worklogDate <= "2021/07/13"

This will consider the time value as - "2021/07/13 23:59"


This is what I have identified. 
if someone is writing queries like below to get the details for the ones who have worked on the issues the team has worked on yesterday with the help of their worklog. 

worklogDate >= startOfDay(-1) AND worklogDate < startOfDay()

 

 

 

2 comments

I think, I've made my findings clear. 

Wasn't sure where I can post this. So that everyone can benefit from this. Hence posted as a question. 

Jack Community Leader Jul 15, 2021

Thanks for sharing @Viral Doshi .  I thought I would add another useful JQL reference here…

what-is-advanced-searching-in-jira-cloud 

in that article you will find a great deal of information about advance searching.

Comment

Log in or Sign up to comment
TAGS

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