You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

RPL Personalization with Last Record Update in Supplemental Table

Received Response
11
Views
1
Comments

Hi There,

I've designed an E-mail Campaign using RPL and a SQL View as an Audience. My idea is to send an E-mail when my Customer's product is about to end. Therefore I need to retrieve some information in my Supplemental table ORDERED BY THE LAST UPDATE, which in SQL would be something like ORDER BY MODIFIED_DATE_ DESC, but when I Schedule it uses the last information of my Supplemental table based on CODPRO (SKU/PRODUCT CODE in my Supp).

Here my HTML code with RPL:

<#data PRODUTOS as prod limit=1><#filter CUSTOMER_ID_1=Petz_Nova_Base_Unica.CUSTOMER_ID_><#fields DESCPRO LINKPRO URLPRO><#assign DESCPRO = PRODUTOS.DESCPRO LINKPRO = PRODUTOS.LINKPRO URLPRO = PRODUTOS.URLPRO>                    <table align="center" bgcolor="#ffffff" border="0" cellpadding="0" cellspacing="0" width="600">                      <tbody>                        <tr>                          <td height="30">                          </td>                        </tr>                        <tr>                          <td align="center" valign="top" width="35%"><a href="${PRODUCT_URL}?utm_source=ClaraVista&utm_medium=crm&utm_campaign=Recompra" target="_blank"><img height="180" src="${URLPRO}" width="180" /></a>                          </td>                          <td style="padding: 0 20px 0;" valign="top" width="65%"><span style="font-size: 23px; color: #007dc5; font-weight: bold; display: block;">${DESCPRO}</span> <a href="${LINKPRO}}?utm_source=ClaraVista&utm_medium=crm&utm_campaign=Recompra" style="display:block; margin-top: 50px;" target="_blank"><img src="btn_rec.jpg" /></a>                          </td>                        </tr>                        <tr>                          <td height="35">                          </td>                        </tr>                      </tbody>                </table>                    </#data>

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!