Derive value of custom field as at a given date

Question

Hi

I have a need to track month on month changes to a given custom field in JIRA.

Is it possible, using Scriptrunner, to derive what that custom field value was at the start of the current month, the start of the current month -1  or the start of current month-2?

Nic Brough -Adaptavist- · Answer

Not to hand, but https://library.adaptavist.com/entity/count-the-time-an-issue-was-in-a-particular-status shows a good example of how to start reading the history of an issue for something.

graemejohnson · Answer

Apologies if this is cheeky @Nic Brough -Adaptavist- , do you have an example to hand that you could please share?

Nic Brough -Adaptavist- · Answer

Yes, you can read back through the issue history with SR, looking at the changes to a custom field in order to establish when it changed (if you don't find a change record, then the current value is what it was on the date you're looking for)