Scriptrunner: Finding the min and max dates of a group of stories related to an epic

J C_afz41z

Hi,

I'm trying to find the best way to find the min and max dates of two custom fields of a group of stories related to an epic.  We have two custom fields that we would like to get the earliest date and the latest date of and have the scripted field update in the epic it is related to.  Any references/thoughts/suggestions of a ScriptRunner flow that would assist with that task?

Thanks in advance!

Aidan Derossett [Adaptavist]

Hey James!

So, to clarify, are you saying that you want to pull two custom field values from an epic (which both consist of a list of stories related to that epic), and then, for each custom field, get the stories with the minimum and maximum dates? Then, once you find those, you want to output those stories to a script field? Additionally, what are the dates that you're referring to? Resolution dates, creation dates, etc...?

I can give you a better answer after you confirm the above, but conceptually, in a script field you could grab the values from those custom fields (assuming they are issue keys or something), get their associated issues, loop through the issues, and then do some sort of comparison using the java built-ins for Date objects: Date.before(Date), Date.after(Date), etc... While looping through, you could store the issues with the lowest and highest dates in variables to be returned later.

Again, I could probably code something up as an example after you answer those questions!

Thanks!

Aidan