Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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 Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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 Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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