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

Question

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!

Beverly Braham-Durica_p9l2mw · Answer

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

Beverly Braham-Durica_p9l2mw · Answer

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

Mehmet A _Bloompeak_ · Answer

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.