I'm trying to query for time spent on issues. I'm looking at it a couple of ways, and the numbers never seem to match.
Can someone help with more details on these?
startOfWeek() - is this a rolling one week period, or is it the previous Monday?
If I use, worklogDate > startOfWeek(), will I get the work logged so far this week?
And if I use, worklogDate > startOfWeek(-1), will I get the work logged the week before?
Or is there any other suggestion on a better query?
When you use JQL to search for time spent, you always risk to be misled. A Jira filter does not return time spent, it returns issues. And so, if you run a search like this:
worklogDate >= startOfWeek()
... that will effectively return all issues with hours logged after the beginning of this week. But, these issues may have hours logged from earlier dates as well and they will show up in your time spent / remaining estimates counts.
Reporting on time spent is an area where I would really recommend taking a look at marketplace apps. While Jira does offer the core functionality to add time spent to an issue, it is not particularly good at reporting on it, not mentioning building some solid processes around that information.
Hope this helps!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.