Can anyone help me with a sample email notification, with query which has a relationship to the item as well as html with a loop which displays that relationship. A good example can be of ECN to Affected items i.e. documents/
If you expand a bit more what kind of loop you want, I'm sure I can point you in a more specific direction, but a query with a relationship might look something like the following:
<Item type="ECN" action="get">
<Item type="ECN Affected Item" action="get"/>
You'd have to sort out exactly what information you want- the above is just going to dump most of the output on you- but my understanding is you've got that part and you're just looking for how to get at relationships. For queries which you want to go deeper and deeper, an alternative to nesting can be something like getting repeating items with the same structure. Take a look at the GetItemRepeatConfig instruction in this article, and let me know if that helps.