when trying to use the worklogged function
issueFunction in workLogged( "after 2014-08-01", "before 2014-08-30" )
is there a way to use the startofmonth() and endofmonth() with it for e.g. like
issueFunction in workLogged( "after startofmonth()", "before endofmonth()" )
Not sure who Downvoter is
But the workarounds which have been suggested have one flaw
1) it has to be a per person thing since you cannot use the group or role level
2) if an issue has a work log 2 months old and the person recently made a change to comment on it it would show up
3) the workaround can be implemented with jiras existing columns
updated > startofmonth() and updated < endOfMonth() and timespent is not EMPTY
I needed that function too. But as stated in documentation https://jamieechlin.atlassian.net/wiki/display/GRV/Scripted+JQL+Functions#ScriptedJQLFunctions-workLogged(worklogquery) you can use either date YYYY-MM-DD or date expressions e.g. w, d, h, m.
You can also try to sort issues if they have been resolved during the period but it's not very precise:
CHANGED after startOfMonth(-1) before endOfMonth(-1) AND issueFunction in workLogged("by assignee")
By "not very precise" I mean this function is good when you have worklogs only in one period but if you have a big tasks with several worklogs - you will get it both in current and previous periods. For example, if you have a task with worklogs on July 31 and August 1 - it will be shown both in searches for this month (using startOfMonth()) and previos one (using startOfMonth(-1))... Still for me that wasn't a big problem.
Gulfam, unfortunately it's not possible.
Alexander - that seems like a good workaround, with a slight adjustment:
updated > startofmonth() and updated < endOfMonth() and issueFunction in workLogged("by admin")
Downvoter - what's wrong with that?
Yes, my syntax is wrong... It should be:
status changed to "Complete" after startOfMonth(-1) before endOfMonth(-1) AND originalEstimate != 0 AND issueFunction in WORKLOGGED("by user.name") AND issueFunction in aggregateExpression("Estimated", "originalestimate.sum()", "Work Logged", "timespent.sum()")
...and that will make a report if employee user.name have managed to meet original estimates on completed tasks last month.
Hello! My name is Genevieve Blanch, and I'm the Marketing Manager at RefinedWiki, creators of apps to give teams the tools to customize Atlassian platforms. Currently, 44% of the tech team at Re...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG