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.
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?
@Trudy P 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.
It looks like you're new here. Sign in or register to get started.
