This is a cautionary tale for the Community. I will open a Support ticket for this bug.
Below highlights a mistake that I have spent several hours trying to identify. It is an error that the Editor should catch.
I created an action to “execute and action on a set of rows” . I specified, by design, the same Table name in the “For a record of this table” and the “Referenced Table” properties.
However, I mistakenly used the wrong column in the “Referenced Rows” property. The rows were from a different table. This effectively ends up with NO rows being passed as context to the “Referenced Action”.
The issue is that no error reflected this mistake. It is an obvious user error and should have been caught in the Editor on a Save OR If the “Referenced Table” was set first, then an error in the Expression Assistant when the “Referenced Rows” were assigned.
I hope this helps someone!!
