nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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?

Accepted answers

Endy Tjahjono

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.

All comments

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

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.

Endy Tjahjono

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud

filter

subscription