Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

filter tickets specifically by time of day

abdelilah nassiri
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 25, 2023

I want to make a filter that brings tickets from 5h30 AM to 5 PM & 5PM to 5h30 (the following Day), Using JQL Queries, Any Help Please, Thanks in advance

1 answer

0 votes
Tansu Akdeniz
Community Champion
May 26, 2023

Hi @abdelilah nassiri 

Welcome to the community. Here is an example:

  • created > startOfDay(5h) and created < startOfDay(17h)

You can use minutes too.

Further info: Advanced search reference - JQL functions 

abdelilah nassiri
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 26, 2023

Thanks @Tansu Akdeniz  is there any possibility to use or add minutes in this clause (startofDay) like StartofDay("+5h30m"), because i tried all ways but all in vain

Tansu Akdeniz
Community Champion
May 26, 2023

You are welcome. Just convert hours to minutes.

  • Ex: startOfDay(300m)

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events