Accessing fixVersion.ReleaseDate of an issue in Structure

Kristina Volokhovska
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 3, 2021

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!

3 answers

1 vote
Rajeev Gupta
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
September 21, 2023

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.

1 vote
David Niro
Atlassian Partner
October 26, 2021

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
Contributor
October 27, 2021

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

Like Dave Rosenlund _Trundl_ likes this
David Niro
Atlassian Partner
October 27, 2021

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

Like # people like this
Ian Porter
Contributor
October 27, 2021

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

Thanks for the help!

Like David Niro likes this
Zohar Eshed December 3, 2024

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_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 4, 2024

@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)

Like Zohar Eshed likes this
Zohar Eshed December 4, 2024

works perfect! you're right.

10x

Like Stepan Kholodov _Tempo_ likes this
0 votes
David Niro
Atlassian Partner
March 4, 2021

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
Contributor
September 24, 2021

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
Atlassian Partner
September 27, 2021

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

Like Dave Rosenlund _Trundl_ likes this
Ian Porter
Contributor
September 27, 2021

@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 November 15, 2022

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_
Atlassian Partner
November 16, 2022

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]

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events