Jira Custom Filter

[Shah Baloch]

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

[Kat Warner]

Something similar to this might work:

"Start Time[Time stamp]" >= startOfDay(1) AND "End Date" = startOfDay(8)  with the bold values being updated to match your customer fields.

[Shah Baloch]

Thank you @Kat Warner I tried the above method but for some reason, it is displaying "No issues were found to match your search". There are 7, 8 issues. I'm including screenshots that might help.

I'm looking at the logic, that tickets have a start date/time Tuesday time is greater than 9 am and the End date/time next Tuesday time is equal to 8:30 am.

Here is the query:

project = PCF AND issuetype = Task AND "Start Date/Time" >= startOfDay(1) AND "End Date/Time" = startOfDay(8)

Appreciate your help, thank you,

[Shah Baloch]

I changed the last equal to less than equal and it works. Now, how I can add time, like start date/time is greater than 9 am Tuesday, and the end date/time is equal to 8:30 am next Tuesday.

[Kat Warner]

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.

[Shah Baloch]

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.

[Shah Baloch]

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.