LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: tekaleka

Is it possible for the email node to send more than one row/record per email?

Regards

Mafileo

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ryeh

I think the easiest way to do so would be to use an aggregate node to concatenate the rows. In the example below, we concatenate all the ID's to generate one record, which can then be used to send one e-mail.

************************************
node:Agg_Ex
bretype:core::Agg Ex
editor:sortkey=541f9b152fcd01aa
input:@4b4668c040aa5a85/=Static_Data.40fe6c55598828e5
output:@4b4668e708143fb4/=
prop:GroupBy=<<EOX
1
EOX
prop:Script=<<EOX
if firstInGroup
then val = ID
else val = val + "\n" + ID

emit val
where lastInGroup

EOX
editor:XY=220,260
node:Bypass
bretype:::Bypass
editor:shadow=4b467f7e02db3a85
input:@4b467f7e129d45c1/=
input:@4b467f830ffe047b/=
output:@40fd2c7436717256/=
end:Bypass

node:Sort
bretype:::Sort
editor:shadow=4b467f8972dc33df
input:@40fd2c743ebf4304/=
output:@40fd2c746a2a3b47/=
end:Sort

node:Agg
bretype:::Agg
editor:shadow=4b467f9b3d5028c0
input:@40fd2c7427456e5b/=
output:@40fd2c744c862db0/=
end:Agg

end:Agg_Ex

node:Static_Data
bretype:core::Static Data
editor:sortkey=541f9af54b0a6663
output:@40fe6c55598828e5/=
prop:StaticData=<<EOX
ID
456
23
654
3578
6656
EOX
editor:XY=120,260
end:Static_Data
************************************

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: tekaleka

thanks.

I now have the issue of the email node not sending the data in the format i want. I have all my data in 1 row with multiple columns now after executing the aggregated node,but the format of the received email is just one column.

Anny suggestion.

Regards