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; } } }

How get I daily status change

Sara.B

I have built this filter to see the tickets which are going to status analyzed in a daily basis:

status changed To Analyzed DURING (startOfDay(),endOfDay())

Can someone help me to find out what is wrong with the filter, because it does not show any result and yet there are tickets which status has been changed today.

Regards,

Sara

Accepted answers

John Funk

Hi Sara - Welcome to the Atlassian Community!

Try putting a -1 in and see if anything shows up.

status changed to Analyzed during (startOfDay(-1), endOfDay())

If so, then it is a timing of how your time zone is configured.

All comments

Ignacio Aredez GenAI Expert

If your JQL filter isn't showing the expected results, consider the following steps to troubleshoot:

Check Status Name: Ensure the "Analyzed" status is spelled exactly as it appears in Jira, as JQL is case-sensitive.

Time Zone Settings: Confirm the Jira server's time zone aligns with your intended query period, since startOfDay() and endOfDay() are based on the server's time.

Permissions: Verify you have the permissions to view all issues that might have changed status, as permission restrictions can affect filter results.

If these steps don't resolve the issue, try broadening your filter to diagnose the problem, such as checking for any status changes over a wider date range.

John Funk

Hi Sara - Welcome to the Atlassian Community!

Try putting a -1 in and see if anything shows up.

status changed to Analyzed during (startOfDay(-1), endOfDay())

If so, then it is a timing of how your time zone is configured.

Sara.B

Thanks for feedback. It is working

Valeriia_Havrylenko_SaaSJet

Hi @Sara.B 👋

If you will need more enhanced option i suggest you to try Status Entrance Date report (Time in Status for Jira add-on) that shows the date an issue has moved to a particular status.

With this report you will get dates when the issue has entered each of the statuses on the grid as it’s shown below.

Знімок екрана 2023-07-17 о 15.05.31.png

On the chart, it shows the number of tasks that have entered a status on a certain date - for example, 1 task out of 5 tasks has entered the Progress status for the first time on the 23-rd of May.

Add-on has a 30-day free trial version and free up to 10 users.

Hope it helps 😌

Sara.B

@Valeriia_Havrylenko_SaaSJet thanks for the suggestion. It seems to be a practical solution but I have already found a work around.

Welcome!

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

Quick Links

Find more posts tagged with

jira

unknown-hosting-type