subscription doesn't match actual filter

[Endy Tjahjono]

I have a filter with this JQL:

created >= startOfDay(-1d) AND project = "X" ORDER BY created

I subscribed to this filter daily at 1:00am.

This subscription has ran for 2 days. The first day email matches the result from the actual filter. But the second day email doesn't.

The second day email, which ran at 8 Sep 01:00, contains 25 items, including tickets created on 6 Sep. The actual filter has 16 items and does not include tickets created on 6 Sep.

Did I miss anything? Or is this a bug?

[Endy Tjahjono · Accepted solution]

I changed the query to:

created >= startOfDay(-1d) AND created < startOfDay() AND project = "X" ORDER BY created

And I ran the subscription on 10 Sep 11:27am (by pressing Run Now).

The email that I got contains tickets created on 8 Sep.

When I ran the filter directly, it showed tickets created on 9 Sep.

So it looks like startOfDay uses server's timezone (maybe in the US) instead of my timezone (UTC+7). I consider this a bug in Jira.

[John Funk]

Hi Endy,

Not sure why it would do that other than the time is off somehow. Have you considered running it later in the morning - maybe 3:00 am? And then see if the results are different. Is there a reason it needs to run at 1:00? 

[Endy Tjahjono]

Looks like it is caused by startOfDay uses server's time zone instead of user's time zone (see my answer).