No Followup for 3 Days(Excluding Weekend),

Question

Hello Team,

I have prepared a JQL Query Where it gives me Result for no followup 3 days excluding weekend.

The Query is running fine, but the result is specific to Time, when the ticket was updated.

ie If a ticket was update on Monday at 2pm and if I run the query on Thursday at 1pm I wont get to see that ticket, while if I run the query at 2pm or after that only then I get to see that ticket.

This is more specific to time, While I need it to be specific to the day.

For eg, I need to see all the ticket on Thursday that was last updated on Monday irrespective on time.

Below is the query let me know What to edit more here.

(updated < -3d AND updated > startofWeek(-1d)) OR (updated < -5d and updated < startofweek(-1d))

Could you please suggest here.

Abhishek Pandey_1jotnn · Answer

Im still checking this, Ideally after implementing this query

(updated < startOfDay(-3d) AND updated > startofWeek(-1d)) OR (updated < startOfDay(-5d) and updated < startofweek(-1d))

The result has to be static, ie. If I run the query at 1am on Tuesday and if the query returns the value 5 Jira under my name it has to be the same number the whole day.

After I run this query on next day ie on wednesday then i may expect some other value.

Im still testing the same. let me know your understanding on this.

Thnx

Florian Bonniec · Answer

updated < -3d is supposed to take the date -3d but keep the time , when startofday(-3d) is supposed to do the same thing but use 00:00 instead the hours.

So it should solve your issue.

(updated < startOfDay(-3d) AND updated > startofWeek(-1d)) OR (updated < startOfDay(-5d) and updated < startofweek(-1d))

Regards

Abhishek Pandey_1jotnn · Answer

Hi @Florian Bonniec , Thnx for above.

I have amended my query with your above input. Although im getting the same output for Now.

Not sure if the above ( < startofday(-3d) instead updated < -3d ?) solvees my issue of days instead of timing.

Looking forward for more inputs.

Awaiting response.