Avatar

Correct answer by
Community Advisor

Hi Austin,

See and example of code below. I used broadLogRcp as it has a 1-N relationship with recipient schema. So for every recipient I want to show all the emails sent

In your case, replace broadLog by the name of your 2nd table.

 

<TABLE>
    <TBODY>
        <TR>
            <TD>Campaign name</TD>
            <TD>Delivery Name</TD>
            <TD>Event Date</TD>
        </TR>
        <%
                for(var i = 0 ; i<recipient.broadLog.length; i++)
                {
                    document.write("<tr>");
                    document.write("<td>" + recipient.broadLog[i].delivery.operation.label + "</td>");
                    document.write("<td>" + recipient.broadLog[i].delivery.label + "</td>");
                    document.write("<td>" + recipient.broadLog[i].eventDate + "</td>");
                    document.write("</tr>");
                }
            %>
        </TR>
    </TBODY>
</TABLE>

 

 

Here is the result

DavidKangni_0-1605233953745.png

Thanks,

David

 

View solution in original post