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 · Accepted solution]

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

[pritchsc]

Perfect! Thanks David - much appreciated.

[David Niro]

You are very welcome!

[Sanjivani Wayal]

Hi @David Niro  

I wanted to get MAX fixversion in structure from all the child issues on the parent issue 

can you please help