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.

[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.

[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 : 

1. Create a select list custom field named "Created after 10 PM" (yes, no) with default value to "no"
2. 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.

[M Amine]

Script fields are (partially) supported in Cloud : link

[GP]

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,

GP