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; } } }

Is it possible to search for issues based on created time (without specifying date)?

Esther Strom

We are looking for a way to report on service desk tickets submitted after 10 PM. We don't care about the date, only the time.

Is this possible? I'm not able to find any JQL that would do it. We do have ScriptRunner with its enhanced search, if that would help.

We're on Cloud.

Accepted answers

All comments

GP_qekgys

No Esther, we can't do this using only time. Date would be there along with time.

Example

created >= "2019/11/13 17:00" AND created < "2019/11/13 23:00"

Thanks,

M Amine

The easiest way, in my opinion, is to create a custom field that you will fill automatically if the ticket is created after 10 PM. For example :

Create a select list custom field named "Created after 10 PM" (yes, no) with default value to "no"
Add an automation rule
1. Trigger : Upon issue creation
2. Add JQL condition "created >= startOfDay("+22h")"
3. If yes => Edit field "Created after 10 PM" and put "yes"

Esther Strom

Thanks, Mohammed. Unfortunately that doesn't help with our existing tickets, which is what we need to get this data for. I think I'm going to have to export the info to Excel and figure things out there, which I hate having to do, but oh well.

M Amine

are you ready to use a script field since you have script runner? if yes you can add a script field in which you take the created and check if it is after 10PM and then return a value. Then you can use JQL on your script field.

Hope it helps.

Esther Strom

We are on Cloud; it doesn't support scripted fields.

RKusmba

As @M Amine has mentioned for new issue creation, similar to that for existing issues - add automation rule based on workflow transition trigger that will go back to the same status.

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud

time