Forums

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

Hours Logged for Last Calendar Week Report

Tarfon, Carla February 13, 2022

I'm having trouble entering a JQL to pull a report for total hours logged for the last calendar week within a specific project. 

I've tried this:

project = "NewsDNA Editorial Design" AND worklogDate >=startOfWeek(-6) AND worklogDate <= endOfWeek(-6)

But no issues or data is coming up (even though it has a green tick). 

Is there another code i should be trying? 

TIA.

1 answer

0 votes
Fabio Racobaldo _Herzum_
Community Champion
February 14, 2022

Hi @Tarfon, Carla ,

you are checking the wrong period.

The correct JQL should be :

project = "NewsDNA Editorial Design" AND worklogDate >=startOfWeek(-1w) AND worklogDate <= endOfWeek(-1w)

Please, let me know if it fixes your issue.

Regards,

Fabio

Tarfon, Carla February 14, 2022

Hi Fabio - i've tried that, however it's not bringing up anything at all. "No issues were found to match your search". Do you have any idea why this would be happening? 

Fabio Racobaldo _Herzum_
Community Champion
February 15, 2022

Ciao @Tarfon, Carla ,

please, could you share one issue screenshot with logged hour?

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events