JIRA Structure - iterate through fix versions, display earliest release date

pritchsc

Hi all, 

Hoping for some insight here!

I'm putting a formula in JIRA structure view that will check the fix versions against a due date and display the earliest date found.

I've managed achieve it with the code below, but there is an edge case, we have many fix versions - some do not have all the data populated. The example here could be that teams create fix versions that are internal, like tags, but do not add a release date, which can lead to dates not being compared correctly. 

I would like to iterate through an array of fix versions checking that releasedate is not undefined, if so then we take the next version, using code below will not weed out those that are undefined. 

fixVersions.UMIN_BY($.releaseDate)

 Any pointers would be  much appreciated. 

David Niro

Hi @pritchsc ,

Is the problem that UMIN_BY() is recognizing undefined release dates as the "earliest"?

If that's right, you could first FILTER() the version array to return only those versions that have a release date populated, and then apply the UMIN_BY() function.

Something like this:

fixVersions
    .FILTER($.releaseDate != undefined)
        .UMIN_BY($.releaseDate)

Hope this helps!

Best,
David