Creating a Jira structure formula to find the date that a certain label was added

[Brandon Toms]

Greetings, Structure ninjas!

I'm trying to craft a Structure formula for a custom column on a structure board that will show the latest date that a particular label (specifically "READY") was added to a Jira story (in case the label was added, removed, readded, etc).  So far I've got this:

history.FILTER($.changes.field = "labels")

.FILTER($.toText.contains("READY"))

.FILTER(!$.fromText.contains("READY")).MAP($.time).MAX()

But it doesn't work, the whole column is blank in spite of rows that should have a value.  Any ideas would be greatly appreciated.

Also, is there a documentation resource somewhere with the class tree for Structure?  I'd love to be able to dig down into a particular class and see its methods, attributes/parameters, etc.  

Thanks in advance!
Brandon

[Stepan Kholodov _Tempo_ · Accepted solution]

Hello @Brandon Toms 

You can try a formula like this:

history.changes.FILTER($.field = "labels" and $.toText.contains("READY")).changegroup.time.umax()

All available Formula column documentation can be found on our Wiki.

I hope this helps. If you need further assistance with the formula, please reach out to us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)

[Brandon Toms]

Yep, that works!  Thanks!