How to get Releases status in Structure?

[Jayadev]

Hi Team,

I am creating structure to bring delivery progress view at releases level.

I could manage to create to bring the data view at release group level and also displaying Release start and end dates using formula as fixversions.startdate & fixversions.enddate.

Now I want to add one additional column in structure to show the status of the release (eg: Unreleased, Released, Archived). Please guide how can I bring the status in structure column.

Regards,

J

[David Niro · Accepted solution]

Hello @Jayadev ,

David from ALM Works here.

I see that you have added a tag for cloud and on-prem.  I suspect you are actually on-prem because fixversion.startdate & fixversion.releasedate would not yet work on cloud.

To confirm which could you please check if you see a button called "Automation" or one called "Show Generators"?  If you see "Automation" you are on-prem, the other means you are on Cloud.

If you are onprem, I believe we can find a solution.  What level of the hierarchy are you looking to do this at, the issue level or are you grouping by version and want to see it at the group level?

Best,
David

[Jayadev]

Hi David, Thanks for reply. I am using on-prem (Automation button is being presented in structure).

What level of the hierarchy are you looking to do this at, the issue level or are you grouping by version and want to see it at the group level? - <<Umesh>> I am grouping by version and I want to see at group level.

[David Niro]

Hello @Jayadev ,

You're very welcome!  Thank you for the additional info.

The item property reference we will want to make are .isarchived and .isreleased. These will return a 1 if true and a 0 if false.  Since we want to make the calculation at the Fix Version level of the hierarchy, we will use this rather than fixversion.

From there we can put this into an IF conditional statement to return the text you are looking for.  Please give the formula below a try.

IF !issuetype AND this.isarchived = "1":
  "Archived"
ELSE IF !issuetype AND this.isreleased = "1":
  "Released"
ELSE IF !issuetype:
  "Unreleased"

Please let me know if this works for you.

Best,
David

[Jayadev]

Hi David,

Many Thanks. This has worked. cheers..

I have one more query associated to it.. I have set two group-by levels in the structure.

1st. By project (I am building the structure for multiple jira projects)

2nd. By Releases level

With the provided logic, I am getting status value at Project group level and and Releases level.

How I can restrict this logic to only Project group level?

[David Niro]

Hello @Jayadev ,

You are very welcome.  Glad to hear it worked for you!

How I can restrict this logic to only Project group level?

Do you mean only Release level?  If so, we can refine the !issuetype piece of the formula (see below).  If not, I assume that the Project has multiple releases with different "statuses".  How would you like to visualize this?

IF itemtype = "version" AND this.isarchived = "1":
  "Archived"
ELSE IF itemtype = "version" AND this.isreleased = "1":
  "Released"
ELSE IF itemtype = "version":
  "Unreleased"

Please let me know if this helps.

Best,
David

[Jayadev]

Hi David,

Structure rules as below -

Group by Project
Group by Fix Version/s
Insert issues: project in ("PROJA","PROJB") and Sprint in (openSprints(),closedSprints(),futureSprints()) ORDER BY fixVersion DESC

I am trying to display Release status only at Fix Version/s Group level. I want to refrain showing at Group by Project level.

Tried the IF logic shared by you and its not giving any result. I suspect itemtype = "version" need to be revisited..

[David Niro]

Hello @Jayadev ,

Thank you for the clarification.  Based on what you have mentioned, the proposed formula itemtype = "version" is the right solution.

That it's not working for you is strange.  To check what itemtype = should be, please add a new formula column to your structure and add only itemtype.

It should look like this:

What you see in the field should be swapped out where I have "version".

Please let me know if this helps.

Best,
David

[Jayadev]

Hi David,

Thanks for further help. While adding the rules to the structure, I have grouped fixedversion as an attribute. Post amending it to field, the logic has started giving the desired result.

Many Thanks,

Jayadev

[Kelly Carlson]

Is there a way to do this in the cloud version?

[Alexander Preston]

I'd like to use this in the cloud version too!

[Stepan Kholodov _Tempo_]

Hello @Kelly Carlson and @Alexander Preston 

At this time it is not possible to access a version's properties through a group in a structure in Structure Cloud. We have this feature in our backlog; once there is an update on it, we will send a notification in this post.

Best regards,
Stepan Kholodov
Tempo