List tickets updated since the beginning of the last workday?

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.)

Thanks!

2 answers

0 vote
Ignacio Pulgar Community Champion Nov 08, 2016

Hi Mikhail,

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.

 

Thank you, the idea to catch assignee-changes is an important one. But, it seems, you don't know any function that would refer to the last work-day either – you'd just use a separate filter on Mondays, right?

Ignacio Pulgar Community Champion Nov 09, 2016

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

Ignacio Pulgar Community Champion Nov 09, 2016

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).

0 vote

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.

if it's a Monday, just subtract 3 days instead of one.

That's the question, is not it? How would the query figure out, whether it is Monday or not?

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

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,301 views 14 20
Join discussion

Atlassian User Groups

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!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot