if I change the query to
$([^Incident# where IncidentNumber == $((ParentNumber))]Email))
I get this response:
ERROR: Unknown NodeKind: SubExpression.
I don't think you need to as it is a explicit relationship 1:N therefore there can only be one Incident Owner Email address:
$([Incident#]OwnerEmail) should work will test shortly.
$([^Incident# where IncidentNumber == "$((ParentNumber))"]Email)
ERROR: Error converting data type varchar to numeric.
That works - and shows how much I like to overthink things.
1 of 1 people found this helpful
It works you will get the warning:
The relationship reference
[Incident#.]refers to the relationship
Incident#. Make sure this is what you intend.⁽¹⁾
If it was N:1 or N:N it wouldn't work.
This will only populate if triggering from the incident object if the relationship is to another object it will just be ignored as it cannot find the parent to relate back to.