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

Error at linking 2 Sup Tables with RPL

Received Response
11
Views
1
Comments

Hello There,

I'm facing a strange error in my campaign. I'm trying to retrieve data from a sup table of policies and from another sup of brokers. My Contact List links with my policies' sup by fields POLICIES_ID = CONTACT_LIST.CUSTOMER_ID_, and policies' sup links with brokers' sup by BROKER_ID1 = p.BROKER_ID. Here's how I wrote the RPL:

<#data POLICIES as p>     <#filter POLICIES_ID = CONTACT_LIST.CUSTOMER_ID_>     <#fields VEHICLE_MODEL VEHICLE_PLATE DT_POLICIE>     ${p.VEHICLE_MODEL}, ${p.VEHICLE_PLATE}, ${converttimezone(p.DT_POLICIE, "America/Sao_Paulo","GMT")?string("dd/MM/yyyy")}     <#data BROKERS as b>           <#filter BROKER_ID1 = p.BROKER_ID>          <#fields NAME PHONE>          ${b.NAME}, ${b.PHONE}     </#data></#data>

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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