Hours Logged for Last Calendar Week Report

Question

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.

Fabio Racobaldo _Catworkx_ · Answer

Ciao @Tarfon, Carla ,

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

Tarfon, Carla · Answer

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 _Catworkx_ · Answer

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