JQL filter for time without a date

Patrick Windsor November 30, 2020

Hello I am on JIRA Cloud and I would like to know if there is a way to use JQL to filter based upon time and not date. So essentially I want to see all issues created between the hours of 8am and 8pm, again without any date rage.

1 answer

0 votes
ssraghavan November 30, 2020

try this in your sql

created > startOfDay("+8h") and created < startOfDay("+16h") 

Patrick Windsor November 30, 2020

I will try that, but does it not limit itself to the current date? I am looking for a few reasons, I want to back historically and look at all tickets that were opened during off hours versus business hours.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events