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

Brandon Toms November 29, 2024

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.

image.pngimage.png

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

Thanks in advance,
Brandon

0 answers

Suggest an answer

Log in or Sign up to answer