JIRA JQL: How to search on issues closed before a time in the day?

David Parks picture David Parks · Feb 29, 2012 · Viewed 8.1k times · Source

I want to search for issues closed since 10am yesterday. startOfDay("-1d") only gets me from 8am... how do I tack on the last couple of hours?

Answer

Steffen Opel picture Steffen Opel · Mar 1, 2012

Presumably you have configured your working day to start at 8am in the main JIRA configuration and likely configured JIRA to use a limited number of hours per working day as illustrated in section Configuring Time Tracking Settings within Configuring Time Tracking as well. So depending on your actual configuration there might be two solutions:

  • Either you need to use startOfDay("-6h"), assuming your Hours per day settings is 8 like in the illustration linked above.
  • Or you need to use startOfDay("-22h"), assuming your Hours per day settings is 24.

Good luck!