Structure - Mining history records - catching a single field change when multiple fields are changed

[Brandon Toms]

Hey all you Structure gurus!

So I'm trying to use a Structure formula to catch history records of the status changing from Closed to Open on a story.  However, with this syntax:

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

If multiple fields are changed in the same change, that conditional resolves to FALSE.  So I'm not able to catch things like stories going from Closed to Open, because the resolution field is changed in the process.



Any idea how I can get that conditional to resolve as TRUE?  Do I need another filter?

Thanks in advance,
Brandon

[Brandon Toms · Accepted solution]

Actually I figured it out! This syntax worked:

history.FILTER($.changes.field.contains("status"))

hopefully this helps somebody down the road.

[Valerie Knapp]

Hi @Brandon Toms , thanks for your question. 

I tagged the vendor into this post but in the meantime, I normally suggest to check out the app documentation or contact the vendor directly to ask for this type of support if you're not getting anywhere on your own. 

https://help.tempo.io/structure-dc/latest/ 

https://marketplace.atlassian.com/apps/34717/structure-by-tempo-jira-portfolio-management-ppm 

Hopefully tagging the app will help get some more eyes on this for you too. 

Best wishes

[Brandon Toms]

Thanks! Managed to figure it out last night, just posted the solution.