Accessing fixVersion.ReleaseDate of an issue in Structure

[Kristina Volokhovska]

Is there a way in Structure to show (as a separate column for example) the Release Date of a fix version an issue is assigned to?

thanks!

[Rajeev Gupta]

I like the fact we can access the release date of the fix version on a report.

Is there a way to show this date against the Fix Version itself vs. against each of the Jira items within the fixversion.

How do I bubble to the top?

Thanks.

[David Niro]

Hello @Kristina Volokhovska  & @Ian Porter 

With the release of Structure 7.3, it is now possible to add the fixversion release date to a structure via formula column.

• Add a new formula column 
• use fixversion.releasedate as your formula
• under options, choose Date/Time as the format

Please let me know if it helps!  I look forward to your feedback!

Best Regards,
David Niro
www.almworks.com

p.s.  very nice workaround @Ian Porter!

[Ian Porter]

Thanks David, this isn't mentioned in the release notes, anything else worth noting that's not highlighted?

[David Niro]

Hello @Ian Porter ,

You are very welcome!  I just re-read the release notes and you are correct.  We did not call specific attention to this.

For context, it was possible to reference the fixversion date via the Formula Enhancements released in Structure 7.0. However, the date appeared off due to a formatting bug, now fixed in 7.3.

The release notes for 7.0 do highlight some of the things that are now possible with Formulas, but to your point, may not highlight all of the things worth noting. We recently held two Bootcamp sessions covering the formula improvements in more detail; Session I & Session II. Check them out when you have a chance and let us know what you think!

Best,
David Niro
www.almworks.com

[Ian Porter]

those boot camps are amazing, have watched multiple times and scrubbed to the bit i want...very helpful!

Thanks for the help!

[Zohar Eshed]

hi,
if i have 2 releases set for an issue, how would you configure the "Release Date" formula to show both dates?

[Stepan Kholodov _Tempo_]

@Zohar Eshed 

The same formula - fixversion.releasedate - will return release dates for all set versions in an issue; it's not limited to work with a single version only.
Additionally, you can show the earliest or the latest date by adding .min() or .max() to the end of the formula, if needed.

If you have more questions about the formula, please reach out to us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)

[Zohar Eshed]

works perfect! you're right.

10x

[David Niro]

Hello Kristina,

David from ALM Works here.

The fix version release date is actually an attribute of the fix version field.  In other words, it is not a Jira field in its own right.  To add it as a column, it first needs to be added as a field.

One way to solve this, on a Server or DC instance of Jira, is to use Scriptrunner & Structure together. 

With ScriptRunner, you can create a scripted field that retrieves the desired attribute(s).  That field can then be displayed as a column in your structure.

Below is a script example that could get you started.

enableCache = {-> false}
def version = issue.getFixVersions()
version.first().getReleaseDate().format("dd/MMM/yyy")

 Let me know if it helps!

[Ian Porter]

Hey David, 

How come in structure if I group by release i can add a formula that pulls back Version Start Date which is the FixVersion Start Date but it will only apply itself to the grouping line and not each feature underneath?

i thought the Fixversion.startdate would work but its not

[David Niro]

Hello @Ian Porter ,

It is not fully supported at the moment, but we are working on it and plan to have an update very soon.

I will be sure to follow-up!

Best Regards,
David Niro
www.almworks.com

[Ian Porter]

@David Niro 

I have managed a work around at this point which i am not sure about but is working.

i have used parent{start} and applied the start to equal Version Start Date in a sperate column, the same for parent{live}

Now due to my structure grouping by Fix Version this seems to work :) 

[Jason Rittenhouse]

Hello, I'm using your scriptrunner script to copy the version release date to a scripted text field.  One addition I'd like to make is if the fixversion has no date, to put some text indicating that the date was left blank (like just "null").  That way when there are multiple fixversions on the ticket, if some have dates and some do not, it's clear which ones have the dates and which ones are "null".  What would I add to the script to achieve this (but will still just remain blank if there is no fixversion on the ticket at all)?  Thank you!

[Nicholas Ellis _ALM Works_]

Hi @Jason Rittenhouse ,

This should be very simple to do in the Structure formula.  This is how I would go about it:

fixVersion.releaseDate or "null"

Cheers,
Nick [ALM Works]