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

jira jql
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!

Related questions

JIRA JQL searching by date - is there a way of getting Today() (Date) instead of Now() (DateTime)

I am trying to create some Issue Filters in JIRA based on CreateDate. The only date/time function I can find is Now() and searches relative to that, i.e. "-1d", "-4d" etc. The only problem with this …

Read More
JIRA: Searching for all issues with a given link type

Is there a way to query for all issues with a particular link type? For example, let there be a dependency link where an issue can "depends on" another issue. Is there a query to find all issues that depend …

Read More
How do I query Jira to search for all issues that have been resolved within a length of time from when it was created?

For example, let's say I need to find all issues that were resolved within 1 week's time. I need something like: resolved - created < '1w' Another example: Let's say I have 3 issues: 1) created 2 days ago, resolved 1 day ago. 2) created 5 …

Read More