nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Find all issues created outside of normal working hours

IT_23ot66

Good Day,

Trying to find a way to list all issues created outside of normal working hours (8am to 4pm) for a given period (e.g. previous quarter)

Is there some way to do this in JQL?

Accepted answers

Bill Sheboy

Hi @IT

If you want to run this query for a single, specific day, the built in advanced JQL functions would help you create a saved filter...and you could then schedule that to notify you.

If instead you want to run this for all existing and future issues, that is not possible with out-of-the-box JQL features. You would need to:

need this often: purchase a marketplace addon for JQL to enhance search features
need this infrequently: export the issues to a spreadsheet for analysis
have an on-going need for this, and do not want to purchase an addon: using a custom field and automation rule, split out the time from the data/time for created to allow searches with built-in JQL features

Kind regards,
Bill

All comments

Craig Nodwell_7eve9b

I would imagine you could test on something using the startOfDay() endOfDay() combo.
Re: project = xyz and updated < startOfDay("+8h") and updated > startOfDay("+16h")
I don't have access right now but I would think something along those lines should give you what you are looking for.

Hope that gets you started

Craig Nodwell_7eve9b

For your review.

Advanced Searching In Jira

IT_23ot66

Thanks for the tip,

No joy unfortunately, tried using this -

project = ITSM AND created < startOfDay("+8h") AND created > startOfDay("+16h")

and this -

project = ITSM AND updated < startOfDay("+8h") AND updated > startOfDay("+16h")

but for the time range where I *know* cases were created after 4pm (thanks to export to Excel) I still get 0 results

Perhaps is possible to do substring search of the date time field and get time only?

Bill Sheboy

Hi @IT

If you want to run this query for a single, specific day, the built in advanced JQL functions would help you create a saved filter...and you could then schedule that to notify you.

If instead you want to run this for all existing and future issues, that is not possible with out-of-the-box JQL features. You would need to:

need this often: purchase a marketplace addon for JQL to enhance search features
need this infrequently: export the issues to a spreadsheet for analysis
have an on-going need for this, and do not want to purchase an addon: using a custom field and automation rule, split out the time from the data/time for created to allow searches with built-in JQL features

Kind regards,
Bill

Craig Nodwell_7eve9b

Did you try trimming this out a bit.
Re: currently it has to satisfy both AND statements, re: for the one you know that happened at 4pm. And as mentioned above by Bill this is going to measure todays issues since it is looking at startOfDay() meaning today of course.

project = ITSM AND updated < startOfDay("+8h")

project = ITSM AND updated > startOfDay("+16h")

project = ITSM AND ( updated < startOfDay("+8h") OR updated > startOfDay("+16h"))

also again I don't have access right now but try switching your keyword around with created it works with the date functions as well.

project = ITSM AND ( created < startOfDay("+8h") OR created > startOfDay("+16h")) OR ( updated < startOfDay("+8h") OR updated > startOfDay("+16h"))

IT_23ot66

Thanks!

The exporting to spreadsheet worked well for the analysis, though I did also find a cumbersome way to do it using JQL.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud