How smart is LIST_TABLE_START in HTML merges?

Jaymer

It seems like I don't get the expected result from a
LIST_TABLE_START when I'm trying to populate data in an HTML table.

Exactly where am I supposed to put the LIST_TABLE_START(Find Lead WHERE Lead.ps_Owner.ID = RegularUser.ID)
and how smart is it? Does it insert any start/end tags of its own?

I need to produce an HTML Report, per se. Not using the Report Writer. Just trying to merge some attributes into a complex HTML email.

Whats the best way to go about this?

The above HTML stub is very basic.
Here's my real HTML fragment where I need the merge:

          <table border="0" cellpadding="0" cellspacing="0" width="100%" style="max-width: 500px;" class="responsive-table">
                <tr><td><h2>APPOINTMENTS</h2></td>
                </tr><<LIST_TABLE_START(`Find Appointment WHERE Appointment.ps_User=RegularUser and Appointment.StarttimeDATE=CURRENT_DATE ORDER BY Appointment.StarttimeTIME`)>>
                <tr>
                    <td style="padding: 10px 0 0 0; border-top: 1px dashed #aaaaaa;"> 
                        <!-- TWO COLUMNS -->
                        <table cellspacing="0" cellpadding="0" border="0" width="100%">
                            <tr>
                                <td valign="top" class="mobile-wrapper">
                                    <table cellpadding="0" cellspacing="0" border="0" width="60%" style="width: 60%;" align="left">
                                        <tr>
                                            <td style="padding: 0 0 10px 0;">
                                                <table cellpadding="0" cellspacing="0" border="0" width="100%">
                                                    <tr>
                                                        <td align="left" style="font-family: Arial, sans-serif; color: #333333; font-size:16px;">
<<AS_STRING(Appointment.StartTime,'hh:mm a')>>, <<Appointment.Subject>> from <<Appointment.ob_Lead.Company>></td>
                                                    </tr>
                                                </table>
                                            </td>
                                        </tr>
                                    </table>
                                    <table cellpadding="0" cellspacing="0" border="0" width="35%" style="width: 35%;" align="right">
                                        <tr>
                                            <td style="padding: 0 0 10px 0;">
                                                <table cellpadding="0" cellspacing="0" border="0" width="100%">
                                                    <tr>
                                                        <td align="right" style="font-family: Arial, sans-serif; color: #333333; font-size: 16px;">
<a href="tel:<<Appointment.ob_Lead.Phone>>"><<Appointment.ob_Lead.Phone>><<LIST_TABLE_END()>></a></td>
                                                    </tr>
                                                </table>
                                            </td>
                                        </tr>
                                    </table>
                                </td>
                            </tr>
                        </table>
                    </td>
                </tr>


            </table>

customaware

This works.
Check your apostrophes.... ' not `

<table class="tg-table-paper">
  <tr>
    <th class="tg-col1">Date</th>
    <th class="tg-col2">From</th>
    <th class="tg-col3">Message</th>
  </tr>
  <tr class="tg-even">
    <td class="tg-col1"><<LIST_TABLE_START('FIND ChangeDiscussion WHERE ChangeDiscussion IN ApplicationChange.Discussion ORDER BY ChangeDiscussion.Date DESC')>><<ChangeDiscussion.Date>></td>
    <td class="tg-col2"><<ChangeDiscussion.SentFrom>></td>
    <td class="tg-col3"><<ChangeDiscussion.ChangeMessage>><<LIST_TABLE_END()>></td>
  </tr>
</table>

Jaymer

This is what I'm trying to send as an Email.

Should I be creating this in the Report Generator?
or Word?

I want to send it as HTML Email, not a PDF.
The LIST_TABLE_START (which has worked fine for Excel in the past) doesn't work on this complex HTML.
In this example, it was supposed to print 2 rows. The "111" phone # is from the other BO.

Jaymer

mark, doesn't work in more complex example. post coming.

in your example, what happens if you need another <TD> or two AFTER your last merge column.
I bet it chokes.

Jaymer

i know this is complex, but I don't think its ever going to work using LIST_TABLE_START for this project.
Since making this image, i moved the LIST_START UP near the top.
The issue is, after AIM sees that nothing else is going in a row where a merge field is, it ends the row, begins a new row copies in the formatting of that row (which it remembered), begins a new column and gets you ready for the next iteration of data.

Problem is for me, I still have more data from the 1st set (as see in the image) further below in the responsive table (which is like 4-5 tables all together - crazy)

jaymer...

customaware

Where is you LIST_TABLE_END?

Jaymer

mark, i fixed that in the OP.
still had no effect.

I still need to know whats the best method to do this complex HTML merge in Aware.