Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

 

 

 

4 comments

Viral Doshi July 15, 2021

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 Champion
July 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.

Dietrich Lehr
Contributor
March 30, 2022 edited

.

zacharoula_brinia
Contributor
June 15, 2023

Hello,

How can I make the query JQL to show worklogdate = yesterday or last working day somehow? I would like to see the submitted worklogs fpr the previous dates in result.

 

Thank you in advance!

Comment

Log in or Sign up to comment
TAGS
atlassian, aafp, jira migration, marketing collaboration, end siloed work, streamline workflows, kerrie gottschalk, jira cloud admins, unified marketing, process visibility, team efficiency, cross-team collaboration

How Kerrie Gottschalk unified AAFP’s marketing team with Jira

At the American Academy of Family Physicians, siloed marketing teams faced delays and duplicate work. Kerrie Gottschalk shook things up by moving the department to Jira, streamlining processes, boosting visibility, and sparking stronger collaboration.

Read the story
AUG Leaders

Atlassian Community Events