Trouble with finding Jira status changes since yesterday

1
votes

In our current Jira setup (Jira 8.13.10), that I cannot influence btw, I need to find issues that changed to a specific status since yesterday for a board filter.

I came up with this JQL

status in (Closed, Done) AND status was not in (Closed, Done) BEFORE startOfDay(-1d)

which did not give the result I expected. Running this query in a quick filter on a Jira board with 4 different projects returns the issues closed since yesterday for 3 out of 4 projects and if I want to somewhat achieve my desired outcome, I have to slightly modify the JQL to

status in (Closed, Done) AND status was not in (Closed, Done) BEFORE startOfDay(-28h)

Is there some magic per-project setting that defines startOfDay or am I missing something obvious here?

1
jirajql
You don't say in which way the results were unexpected. Presumably there was an issue which had been transitioned which didn't appear? When was it transitioned exactly? – tgdavies

1 Answers

0
votes

startOfDay() will return the start of the day as defined by your user's Time Zone. This can be set on a per user basis on the User Profile page and, by default, will be set to follow the applications default timezone. You will hopefully find that by updating your timezone, you achieve your expected results.

If the default timezone of your server is different to that of the majority of your userbase, I would suggest contacting a site admin and requesting that change, as it can impact reporting.

This of course is unavoidable if your userbase spans multiple timezones, in which case I might suggest picking the most convenient timezone for the majority and asking everyone to think in terms of that timezone when using the application.

If reporting isn't important to your organisation or individual reports won't span multiple timezones, then you will be fine to have individual user timezones, but just keep it in mind when sharing anything JQL based with other user's.