The FKM dataview looks like this:
I would like to store the last value (marked blue) under a variable and pass it to an email alert. Right now I have a defined path alias (see pic) which I grab in the rule with:
set $(trigger) path "triggerDetails" value
but this grabs the null value from the row where the "FAIL" status is detected (marked red). I need the last element from the array, unfortunately I have no idea how to access it. Any helpful suggestions are much appreciated.