JIRA Structure Formula - Last Transition Author

[Milan Pekař]

Hi,

do you have any solution for displaying Author name of last transition?

 

[David Niro · Accepted solution]

Hello @Milan Pekař ,

Welcome to the Community!  Apologies for the delayed response.

You could try something like this:

history.changes
    .FILTER($.field = "status")
        .LAST().changegroup.author

It makes use of the History item property and Array Functions to get the last status update and then return the author of the change.

Please let me know if it helps!

Best,
David

[Milan Pekař]

The formula does not know "History". How can I set this feature?

[David Niro]

Hello @Milan Pekař ,

If it's not recognizing history, you may be on a Cloud hosted instance of Jira.  If this is the case, history attributes are not yet accessible.

At the top of your structure, do you see "Show Generators" (Cloud) or "Automation" (DC / Server)?

If you do see "Automation", history should be working and it would be best to contact our support team directly through our customer portal support.almwotks.com to determine what may be happening.

Best,
David

[Milan Pekař]

Yes, i see button Automation on the headline.

[David Niro]

Hi @Milan Pekař ,

Ok, you are definitely not on Cloud, so you should be able to pick History from the list of attributes.

In your previous screen capture, where you see history, click on the "Manual Specification" option under it and start typing "history".  The correct option should present itself under the Standard Attributes heading.

Please let me know if you find it!

Best,
David

[Milan Pekař]

No, there is currently no option to select the History attribute.

[David Niro]

Hi @Milan Pekař

That is very strange.  Please reach out to our support team directly via support.almworks.com.  

We will want to have a closer look at what is happening.

Best,
David

[Milan Pekař]

I contacted the system admin of the plugin in our company. So we'll see.
Thanks.

[Milan Pekař]

So, we have actually Structure version 7.2, but History.changes are available from version 7.4 and higher. Update will be as soon is possible.
https://wiki.almworks.com/documentation/structure/7.4/data-center-and-server/structure-7-4-release-notes-130885211.html

[Milan Pekař]

Now we have version 8.2.2 and History.Changes is working. Thanks a lot.

USER_DISPLAY_NAME(
  history.changes
    .FILTER($.field = "status").last().changeGroup.author
)

 For current transition to status

USER_DISPLAY_NAME(

  history.changes

    .FILTER($.field = "status" and $.to = "Your status").last().changeGroup.author

)

[Dave Rosenlund _Trundl_]

It's great to hear you now have the right version of Structure, with the feature you needed. And most importantly that it is working as you hoped, @Milan Pekař 👍

-dave