Alert email action with SWQL variables

Same goes with SQL query, just the top one

${SQL: SELECT n.Caption

from [dbo].[Nodes] as N

left join [dbo].[Dependencies] as D

ON n.nodeid = d.ChildNetObjectID

WHERE d.ParentNetObjectID =  '${N=SwisEntity;M=NodeID}'}

The custom alert variables were designed to display a single value, not an array of values.

There is a workaround though, using the sql variable and an option called for xml path where SQL takes the array of values and crunches then into a big chunk of xml that happens to display the way we want inside email clients.

I wrote an example of a query to display dependency lists here

Include more than the top record in an swql query for an email action?