regex for after hours

Question

Hi,

I want to see the tickets created after hours for my project. 6PM - 9AM. Then maybe sort by priority.

project = myproject AND created >= 2013-01-01 AND created <= 2013-12-15

how do i add created time as a filter here? I didn't see a filter for that. I use JIRA v5.2

Aniket Bodhanka · Answer

ok. I'll post if I can create one. Also i was thinking on the lines of these unsuccessfully: project = myp AND created >= 2013-01-01 AND created <= 2013-12-15 AND ( created < startOfDay() OR created > endOFDay() ) project = myp AND created >= 2013-01-01 AND created <= 2013-12-15 AND created not in ( startOfDay(),endOfDay() ) project = myp AND created >= 2013-01-01 AND created <= 2013-12-15 AND startOfDay("-9h")

Bhushan Nagaraj4 · Answer

Right I see what you mean. Dont think there is a filter based only for time. You might have to write your own jql function. Also its something I might want to add here

https://bitbucket.org/bhushan154/jira-miscellaneous-jql-functions/wiki/Home

Aniket Bodhanka · Answer

Agreed, but this is for one day! I am running this query for a year. I dont want to keep manually incrementing day by 1.

Also, AND ( created <= "09:00" OR created >= "18:00") is invalid.