Days since last "reminder" (custom field)

Questions & Answers
1

Hi,

I have create a custom JIRA field “Reminders”. This one can contains one or multiple JIRA users.
It is a simple list of users.

For every user, I wish to compute the number of days from the last assignation (up to today).
Only if the user is still in the list, of course.

It shoudl looks like something like that, but I do not know how to get the last assignation for the user.

DateDiffDays(
[Reminders].XXXX,
Now()
)

If you have any idea, it will help a lot.

Thanks

2

Hi @cdemez,

eazyBI eazyBI can let you define and import change history for numerical and single-value custom fields.
A multiple-value user picker field, unfortunately, does not fall in the above categories.
Since eazyBI does not import the change history for the field, it will not be possible to report on the last assignment with the standard setup.

It might still be possible to create a JavaScript-calculated custom field measure with multiple dimensions that finds the last assignment date for the currently present users.
That might first retrieve the list of current users and then iterate through the issue changelog to find the last assignment timestamp, after which the value has not been removed from the multi-value list.
The exact script has not been created yet.

You might find samples of Javascript Calculated custom fields for inspiration here - JavaScript calculated custom fields.

Regards,
Oskars / support@eazyBI.com

1 Like