1

Assuming I have hours per day set at 8 and start time set at 9.00 am how can I narrow down tickets using a JQL filter for tickets created between 9.00 am and 10.00 am? I was thinking something like: 

AND updated > startOfDay() AND updated < startOfDay("+1h")
Brian Tompsett - 汤莱恩
  • 5,753
  • 72
  • 57
  • 129
onetruescottsman
  • 21
  • 3

2 Answers2

0

Please see my answer here: Filter issues updated by particular user in period of time using JQL

It seems like you are asking the same question. Hopefully this helps you out.

Community
  • 1
  • 1
Martin
  • 311
  • 1
  • 2
  • 20
0

A scripted field using Script Runner plugin will show the hour:

import java.util.Calendar
Calendar cal = Calendar.getInstance()
cal.setTime(issue.created)
cal.get(Calendar.HOUR_OF_DAY).toString()
Oles Hnatkevych
  • 93
  • 3