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.
Hello, @Tarfon, Carla
Could you try this query?
project = "NewsDNA Editorial Design" AND timespent is not EMPTY AND resolved >= 2022-02-07 AND resolved <= 2022-02-14
Hi Edpo,
I've tried that query, however it's not bringing up any issues/data at all. I'm not sure why...
Would the above also mean i'd have to amend the date every week i'd like to run it? Ideally, i'd like a query that stays live and updates automatically to the previous calendar week ongoing... Not sure if this is all possible...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.