Hi,
I have setup a JQL to bring me back a count of issues that were in "On Hold" during the course of last week. Query is as such:
project= XXX AND issueType = project AND status was in ("On Hold") DURING (startOfWeek(-1w), endOfWeek(-1w))
This currently returns 8 issues when I am expecting 9. On investigation i discovered the the one issue that was not counted was updated on sunday evening at about 10pm.
Question: What time does startOfWeek() start and endOfWeek() end? Does it run from Monday 00:00 to sunday 23:59?
Note: Our JIRA locale is set to GMT +2. We are in South Africa.
Hope you clever buggers can help. :)
Thanks
Hi Jack,
startOfWeek() starts Sunday 00:00 h
endOfweek() is Saturday just before Midnight
Cheers,
Udo
Thanks for the feedback Udo. Is this configurable that the start of the week can be set to Monday 00:00 and end of the week be Sunday midnight? This would make it easier for us.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You're welcome, Jack. Please see this answer.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
you read from
and may you find solution.
and try if you interest to set propeties
https://confluence.atlassian.com/display/JIRA/Setting+Properties+and+Options+on+Startup
but keep a copy of original setenv.bat
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks again Udo and thanks as well to Bharadwaj. I will pass this info onto our administrators to get it changed.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This is an easy one, no need for admin. If you want the current week to be Mon-Sun, use "startOfWeek(1d), endOfWeek(1d)". If you want the previous week to be Mon-Sun, use "(startOfWeek(-6d), endOfWeek(-6d))", and so on.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Rebecca!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
When would you use startOfWeek(1w)?
I had a query that set 1w and setting 1d (monday) does the same thing. Now I'm confused.
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.