Advanced searching between hours of the day

[Geir-Stian Svendsen]

Say, if I wanted to search issues that were resolved between 08:00 and 16:00, how would the syntax look?

I've found out how to search specific times, but thats not really helping.

hope you guys can help.

[Pazera Blazej]

Hi All,

Above examples shows only how to search issues from certain day.

What if i would like to search for all issues ever, created between 08:00 and 16:00.

Cheers.

[GilesG]

Hi Geir-Stian and milowe,

@milowe, I think your syntax for the 'startOfDay()' function is correct, but according to our Advanced Searching page in our JIRA documentation (which is effectively a JQL reference guide), I don't believe you can use the 'resolved' field with the 'startOfDay()' function together in a JQL clause.

Try the following syntax instead:

resolved > "yyyy/MM/dd 08:00" AND resolved < "yyyy/MM/dd 16:00"

where 'yyyy/MM/dd' represents the date - e.g. the current date.

See the 'Resolved' field on the 'Advanced Searching' page for details.

Cheers,

Giles.

P.S. Having said that, please correct me if I'm wrong (so we can fix up the documentation :-) ).

[Mikael Löwenadler]

Well Giles, your are supposed to be the expert :)

Your example is correct for any Jira version.

The example I provided is valid for Jira version 4.3+ when I think relative dates such as startOfDay was intoduced.

The relative dates are more useful if you use filters since you dont have to retype the dates for each search.

[Mikael Löwenadler]

I forgot to mention that I actually tried my jql query for correctness before posting.

[GilesG]

Aha - thank you milowe! Looks like our documentation needs updating :-) Will get on to that.

Thanks!

[Mikael Löwenadler]

Sure thing. This of course also applies to simiiar fields such as created, updated,...

[GilesG]

Thanks milowe,

FYI - I've made the following update to the 'Advanced Searching' documentation:

• The 'Supported Fields' section of the 'startOfDay()' function description (as well as the equivalent 'Supported Fields' sections of the other applicable function descriptions on that page).
• The 'Supported Functions' section of the 'Resolved' field description.

These updates have also been implemented on the equivalent page of the JIRA 5.0 (Beta) documentation.

Cheers,

Giles.

[Mikael Löwenadler]

resolved > startOfDay("+8h") AND resolved < startOfDay("+18h")