Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

filter tickets specifically by time of day

abdelilah nassiri
abdelilah nassiri 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

Answer
Watch
Like Be the first to like this
293 views

1 answer

0 votes
Tansu Akdeniz
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.
Become a leader
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 

View More Comments
abdelilah nassiri
abdelilah nassiri 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

Like
Tansu Akdeniz
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.
Become a leader
May 26, 2023

You are welcome. Just convert hours to minutes.

  • Ex: startOfDay(300m)
Like
Reply

Suggest an answer

Log in or Sign up to answer
Jira Service Desk
Jira Service Management
TAGS
AUG Leaders

Atlassian Community Events

    See all events