How to get time only by using JQL's in Advance Search

[Tahir Mehmood]

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.

[Sreenivasaraju P]

Hi @Tahir Mehmood ,

As per my knowledge, out of the box this feature is not available.

You can try this with silJQLExpression of Power Scripts - Jira Workflow Automation

https://appfire.atlassian.net/wiki/spaces/PSJ/pages/15489314/Custom+JQL+Searches 

[Tahir Mehmood]

Please share JQL if possible

[Iryna Komarnitska_SaaSJet_]

Hi @Tahir Mehmood ,

My team released a useful gadget for dashboard Text to JQL . It's free, and in my opinion, it can help to solve your problem. 

✅With Text to JQL gadget you can:

• Transform user natural-language text into a JQL query
• Create JQL queries by voice
• Gadget is customizable and accepts requests of different complexity
• Receiving results of query in 1-click

[Tahir Mehmood]

Good but it's not right solution what i requested