Need JQL for the tickets opened (created) prior to 7AM and After 5pm form the beginning.

Question

Hi All,

Need JQL for the tickets opened (created) prior to 7AM and After 5pm form the beginning(all available data till now) with component.

Krishna Prasad Kommineni · Answer

Hi @Ismael Jimoh

Thank you for the reply.

Ismael Jimoh · Answer

Hi @Krishna Prasad Kommineni

Jira only affords you datetime field out of the box. Hence if this were a single day, you can enter the exact datetime you want.

For example

Created >= “your date time” OR Created >= “Your date time after 5”

Else you may need to check if an addon offers such a feature by going to marketplace.atlassian.com and looking through all addons with JQL added in.

Cheers