Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Filter date and time (out of hours)

Carl Ekholm
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 4, 2018

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

 

 

 

1 answer

1 accepted

2 votes
Answer accepted
Sergey Sukhaninskiy
Contributor
May 4, 2018

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

Carl Ekholm
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 4, 2018

Thank you!

 

And - Updated was my intention, created was a typo :)

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events