How get I daily status change

Sara_B February 13, 2024

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

3 answers

1 accepted

1 vote
Answer accepted
John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 13, 2024

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 February 13, 2024

Thanks for feedback. It is working 

Like John Funk likes this
0 votes
Valeriia_Havrylenko_SaaSJet
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
February 15, 2024

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.

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

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

Hope it helps 😌

Sara_B February 22, 2024

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

Like # people like this
0 votes
Ignacio Aredez
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 13, 2024

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.

Suggest an answer

Log in or Sign up to answer