Forums

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

Worklogs - JQL query

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!

1 answer

0 votes
Mark Segall
Community Champion
June 15, 2023

Hi @zacharoula_brinia - To get just yesterday, you can do this:

worklogDate >= startOfDay(-1) and worklogDate < startOfDay()
zacharoula_brinia
Contributor
June 15, 2023

Thank you! Do you may know what is the smart value of the last worklog?

Great help!

Mark Segall
Community Champion
June 15, 2023

I'm not 100% on that one.  The documentation states that the worklog smart value is meant for rules that are triggered by worklog.  So if you're wanting to capture the last worklog entry with any other type of trigger, you may need to leverage the Send Web Request action.

I'll defer to other community members in case someone else has figured out the secret sauce on this one.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Product Admin
TAGS
atlassian, confluence, loom, atlassian intelligence, ai notes, ai-powered meeting notes, atlassian community events, ace, confluence ai, loom ai integration, ai note-taking, atlassian ai features, team '25, atlassian live learning, confluence automation

Unlock AI-powered meeting notes: Join our live learning session! 📹

Did you catch the news at Team ‘25? With Loom, Confluence, Atlassian Intelligence, & even Jira 👀, you won’t have to worry about taking meeting notes again… unless you want to. Join us to explore the beta & discover a new way to boost meeting productivity.

Register today!
AUG Leaders

Atlassian Community Events