Filter date and time (out of hours)

Carl Ekholm

Hi!

 

Im trying to get a filter working for issues updated the current year, from 17:00 and later, until the next day not later then 08:00.  This is meant to show how many issues were created during "out of hours", a.k.a the night staff.

 

 

So far, i've written it like this, which gives me correct results, but only for the last day. I want the search to include ALL days, from either startOfYear or any given date. Is there a way to do this?

 

project = "123" AND updated > startOfDay("-7h") AND updated < startOfDay("+8h")
 

 

 

 

Sergey Sukhaninskiy

Hi.

Why you use "updated" if you need "how many issues were created during "out of hours""? 

Try use "created".

 

For all days, you need use plugin like ScriptRunner for Jira

http://scriptrunner-docs.connect.adaptavist.com/jiracloud/enhanced-search.html#_dates 

Or special for reports eazyBI Reports and Charts for Jira