created startOfDay("+3h") and createdDate

Question

So I ran into an interesting problem. I want to filter for tickets created at a certain time of day. But in a different time zone than system time in Jira. And this time period overlaps over two days in system time in Jira.

For example:

System time 0:00   My time: 9:00

I want to filter for tickets My time: 3:00-18:00

In System time that is: Yesterday 18:00 - Today 11:00.

The query is running in System time.

Any ideas how to express that in JQL?

Gaurav_0av1h6 · Answer

Hello @Bojan Virag

As per my understanding, there is a 9-hour difference between your time zone and system time zone.

You need to filter all tickets between 0300 hours and 1800 hours of your time zone; this translates to tickets created between 1800 hours (day - 1) and 0900 hours in the System Timezone.

As we need to look at data from yesterday and today (in System Time Zone), it would be pertinent to know when is this query being run. Assuming it is being run at 1000 Hours system time zone, the query can be:

created >= "-16h" AND created <= "-1h"

This can be further customized to suit your use case.

Bojan Virag · Answer

Thank you, but it is already set to my local time. My experience is different and result differes between when I run the query and when it is ran by Slack integration.

Suvarna Gaikwad_3o435r · Answer

@Bojan Virag I would still suggest to try changing timezone preference in your jira settings as eventually slack is authenticated against your jira account only.