Need field to show days an issue has been assigned to a user, then restart with new assignee

[Beverly Braham-Durica]

Novice with coding in Scriptrunner and I need to find a way to have a field that will show how many days an issue has been assigned to a user. If the issue is reassigned, the count needs to start over.

I've been researching and trying different options and it appears that the best options would be these two paths:

1. Scripted Field

2. A listener

I'm open to either but need help with the actual scripting and any insight from others who have done this.

Thank you!

[Mehmet A _Bloompeak_]

Hi @Beverly Braham-Durica ,

We developed Status Time app for this exact need. By default it provides time spent on each status but it provides report for time spent on each assignee as well.

Once you enter your working calendar into the app, it takes your working schedule into account too. That is, "Assingee time to X user" of an issue assigned to X on Friday at 5 PM and reassigned to someone else on Monday at 9 AM, will be a few hours rather than 3 days. It has various other reports like status time, status entry dates, average/sum reports(eg. average in progress time per project).

Here is the online demo link, you can see it in action and try. Hope it helps.

[Beverly Braham-Durica]

Thank you @Mehmet A _Bloompeak_  - we'll take a look at this 

[Bill Sheboy]

Hi @Beverly Braham-Durica 

Another way to do this to use the automation rules and custom fields.  Using a scheduled trigger (e.g. once per day) you could compare to updated for the days difference.  If you wanted something more accurate, save the Assignee and date/time when it changes to compare to {{now}} 

If this approach looks like it might help, please review this documentation and example rules for ideas:

https://confluence.atlassian.com/automation

https://www.atlassian.com/software/jira/automation-template-library#/label/all/1453

Best regards,

Bill

[Beverly Braham-Durica]

Thank you @Bill Sheboy - I'll take a look at this!