Jira Custom Filter

Question

I need help with creating a filter. I tried but It didn't work. I have two custom date/time fields "Start Change Date/Time" and "End Change Date/Time".  When users create tickets they schedule their change by selecting date and time for example Start: 21/Sep/20 10:00 AM and End 21/Sep/20 11:00 AM.

I will a couple of managers in subscritpion list so that they'll get email every Monday at 8 am.

Filter should pulled those tickets which's start date is greater than 9 am Tuesday and end date/time is next tuesday 8:30 am. How accomplish this by using date/time custom fields?

Thank you

Shah Baloch · Answer

Thank you, I made it work. I was not sure how hours work. Now I understood. Following query working fine for me.

project = PCF AND issuetype = Task AND "End Date/Time" <= "8d 0.5h" AND "Start Date/Time" >= "1d 1h"

Thank you for your help.

Shah Baloch · Answer

Hi @Kat Warner I tried your given query but for some reason, it is displaying an error. I tried the following both queries

project = PCF AND issuetype = Task AND "Start Date/Time" >= startOfDay(1d9h) AND "End Date/Time" = startOfDay(8d8.5h)

project = PCF AND issuetype = Task AND "Start Date/Time" >= startOfDay(1d9h) AND "End Date/Time" = endOfDay(8d8.5h)

Appreciate your help.

Kat Warner · Answer

You may need to experiment along the lines of:

"Start Date/Time" >= startOfDay(1d9h) AND "End Date/Time" = startOfDay(8d8.5h)

I do not have any date/time fields to test with.