Error at linking 2 Sup Tables with RPL
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>
0