You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.
View groupJoin the community to find out what other Atlassian users are discussing, debating and creating.
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.
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.
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.