We have a daily "stand-up" meeting every morning, during which we report, what we've done since the previous such meeting -- during the previous workday.
How do I list my tickets updated during the period? For now I'm using:
assignee = currentUser() AND updatedDate > -1d
but that does not do what I need on Mondays... I know, there is a
startofweek() function, but comparing it with
today() is not working – neither function can be on the left side of the comparision, apparently. Please, advise.
(Would've been nice to have the filter properly recognize holidays in addition to weekends, but such calendar-maintenance would, probably, be too much to ask.)
I suggest saving the following JQLs as filters with descriptive names that help you identifying each of them:
Get all issues where I am (or have been) the assignee and that have been updated yesterday or today:
(assignee = currentUser() OR assignee changed FROM currentUser() AFTER startOfDay(-1)) AND updated >= startOfDay(-1)
Get all issues where I am (or have been) the assignee and that have been updated during last Friday or after:
(assignee = currentUser() OR assignee changed FROM currentUser() AFTER startOfWeek(-3d)) AND updated >= startOfWeek(-3d)
Get all issues where I am the assignee and that have been updated after my specified date and hour:
(assignee = currentUser() OR assignee changed FROM currentUser() AFTER "2016/10/31 08:00") AND updated >= "2016/10/31 08:00"
Hope it helps.
I'm afraid that such a function does not exist. You have a complete list of supported functions here: https://confluence.atlassian.com/jirasoftwarecloud/advanced-searching-functions-reference-764478342.html
It might be a good idea for you to subscribe to the first and second filters properly scheduled, and with the columns (fields) you would like to get. That way, every working day you will have an email with the list of issues you need.
Note that you can also set your subscription to be sent according to a cron expression, so you may potentially create a complex period and, maybe, you can set exceptions (holidays).
This is very similar to https://answers.atlassian.com/questions/38755130 - you could see my gist there.
The code is much simpler though - if it's a Monday, just subtract 3 days instead of one.
Business holidays are a whole different world of pain - depends on your region etc.
Whether the current day is a Monday? That seems like a solved problem, unless I'm missing something. Eg http://stackoverflow.com/questions/5270272/how-to-determine-day-of-week-by-passing-specific-date
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
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot