JQL to pull out Service ticket created after hours for the past 6 months

[Gary Ropers]

Trying to see if anyone has created a query that will pull tickets created after hour (5PM - 8AM) for a time period of 1 to 6 months.

[Trudy Claspill · Accepted solution]

Hello @Gary Ropers 

Native JQL functionality doesn't support filtering a date/time field like Created based only on the time portion.

To do that you would need to get the time portion from the field and store it in a separate Time only field, which could be done with the native Automation for Jira feature.

It might be possible to find a third party app that would allow you to make the time only comparison to a date/time field. Would you consider or do you already have any third party apps that extend the JQL functionality?

[Gary Ropers]

@Trudy Claspill Thanks for the follow up. I extracted the data and used excel functions to filter out the needed information. 

JIRA needs to work on this capability.