Good day everyone,
I have a problem with creating a task report. Our team needs to track delayed tasks and have them shown in our reports.
We log our due dates on every task. I tried 'time in status' but no field can show if the task is done by the due date or past due date.
Does anyone have a solution for this?
Hi @Ariunzaya 👋
Welcome to the Atlassian Community!
It seems that you have already tried using Time in Status builded by my team. For specifically tracking delayed tasks and showing them in a report, we have developed another add-on called Time Between Statuses. With this add-on, you don't organize statuses in a status group as much as you track transitions between them.
You can set up highlights for values that exceed the permissible level. In this case, you will receive a report based on the warning time limit and critical limit. Also, you will receive email notifications about issues that are close to or already past their due time.
Add-on has 30-days trial version, free up to the 10 users and developed by my SaaSJet team.
I hope this helps 😊
Hi @Ariunzaya - Welcome to the Atlassian Community!
I actually do this by add a Delayed status to my workflow. Then I have an Automation rule that rules daily that moves the issue to the Delayed status when it moves past the Due Date.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi John! I'm really interested in this solution. Could you please explain me how it's done?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @José Eduardo Jarrín Sánchez - Welcome to the Atlassian Community!
It's best to create a new question each time for your particular needs, and I would encourage you to still do that for this one. More people will see it.
But basically, you would add the new status to your workflow, then create an automation rule based on a Scheduled trigger that runs daily. Then add a condition where now() is greater than the Due date. Then add a new action to Transition issue to the Delayed status.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello @Ariunzaya
Welcome to the Atlassian community.
Jira does not natively allow you to compare one date field to another date field as part of a JQL filter.
Would you consider acquiring a third party app to accomplish your requirement?
For instance Adaptavist's Enhanced Search has a date compare function that allows you to specify a sub-filyet that compares one date field to another.
https://docs.adaptavist.com/sr4jc/latest/features/scriptrunner-enhanced-search/jql-functions
I see that you specified you are on the Free plan. The above app supports a free use when your instance is on the Free Jira plan.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.