Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,298,327
Community Members
 
Community Events
165
Community Groups

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

 

 

 

3 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 Brickey 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.

what does the worklogDate field actually look for? Is this updated any time a card is touched in anyway? Like commented, description changed, status changed, opened, etc?

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