How to get time only by using JQL's in Advance Search?
My team created alot of jira ticket against end user complaints.
I want to create a dashboard by using Rich filter about jira tickets.
From which time most of jira tickets logged.
For Example:
Ticket 1 created at 01-Nov-2022 15:00:00
Ticket 2 created at 02-Nov-2022 05:00:00
Ticket 3 created at 05-Nov-2022 09:00:00
Ticket 4 created at 10-Nov-2022 18:00:00
Now,
I want to know in which time frame most of tickets logged?
Shift A Time: 00:00:00 - 07:59:59
Shift B Time: 08:00:00 - 15:59:59
Shift C Time: 16:00:00 - 23:59:59
Currently JQL written but this one is wrong method
createdDate >= "2022/11/01 08:00" AND createdDate <= "2022/11/01 13:59" OR createdDate >= "2022/11/02 08:00" AND createdDate <= "2022/11/02 13:59" OR createdDate >= "2022/11/03 08:00" AND createdDate <= "2022/11/03 13:59" OR createdDate >= "2022/11/04 08:00" AND createdDate <= "2022/11/04 13:59" OR createdDate >= "2022/11/05 08:00" AND createdDate <= "2022/11/05 13:59" OR createdDate >= "2022/11/06 08:00" AND createdDate <= "2022/11/06 13:59" OR createdDate >= "2022/11/07 08:00" AND createdDate <= "2022/11/07 13:59" OR createdDate >= "2022/11/08 08:00" AND createdDate <= "2022/11/08 13:59" OR createdDate >= "2022/11/09 08:00" AND createdDate <= "2022/11/09 13:59" OR createdDate >= "2022/11/10 08:00" AND createdDate <= "2022/11/10 13:59" OR
Need a function which can return only time from CreateDate field.
