how to filter tickets created in project from 12:30pm to 9:30 pm IST
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.