how to filter tickets created in project from 12:30pm to 9:30 pm IST

Sachin Guttala
Contributor
October 28, 2024

 

 how to filter tickets created in project from 12:30pm to 9:30 pm IST

1 answer

1 accepted

0 votes
Answer accepted
Humashankar VJ
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 28, 2024

Hi @Sachin Guttala 

Can you give a try with the below JQL:

project = "Your Project Name" AND
created >= startOfDay() + "T07:00:00.000+0000" AND
created <= startOfDay() + "T16:00:00.000+0000"

To make it work for the current day automatically, you could modify it like the below:


project = "Your Project Name" AND
created >= "yyyy-MM-ddT07:00:00.000+0000" AND
created <= "yyyy-MM-ddT16:00:00.000+0000"

Hope this helps - Happy to help further!!
Thank you very much and have a great one!
Warm regards

 

Sachin Guttala
Contributor
October 28, 2024

Hi @Humashankar VJ 

Thank you for your response. I tried the workaround you suggested, but it didn’t work and threw an error. Please find the details attached.Screenshot 2024-10-28 172231.png

Like Humashankar VJ likes this
Humashankar VJ
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 28, 2024

@Sachin Guttala 

Can you update the format from - yyyy-MM-dd to yyyy/MM/dd and give a try.

Regards

Sachin Guttala
Contributor
October 28, 2024

Hi @Humashankar VJ tried that also but not working.

Like Humashankar VJ likes this
Humashankar VJ
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 28, 2024

@Sachin Guttala 

Try this and it worked at my end as i converted the time zone to UTC- Update your Project name alone from the JQL:

JQL:

Project = "Support" AND created >= "2024-10-28 07:00" AND created <= "2024-10-28 16:00"

Regards

Sachin Guttala
Contributor
October 28, 2024

Hi @Humashankar VJ

The workaround worked, but we need to update the date manually every day.

 

Like Humashankar VJ likes this

Suggest an answer

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

Atlassian Community Events