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
Look under the heading "Created" in this document. You can specify the time.
https://confluence.atlassian.com/display/JIRA/Advanced+Searching
Example:
project = myproject AND created >
"2010/12/12
18:00"
and created <
"2010/12/13 09:00"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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")
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.