regex for after hours

[Aniket Bodhankar]

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

[Bhushan Nagaraj]

Look under the heading "Created" in this document. You can specify the time.

https://confluence.atlassian.com/display/JIRA/Advanced+Searching

[Bhushan Nagaraj]

Example:

project = myproject AND created > "2010/12/12 18:00" and created < "2010/12/13 09:00"

[Aniket Bodhankar]

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.

[Bhushan Nagaraj]

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 Bodhankar]

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