Personalization : Fields has relation with recipient table

Avatar

Avatar

ckumari12

Avatar

ckumari12

ckumari12

02-08-2017

I have data such as

brData

BR_Code  BR_Name BR_Manager_Name  BR_Manager_EMAIL_ID     BR_Manager_Phone# 

A               B                    C                    a1@gmail.com                   9123333333

X               Y                    Z                    b1@gmail.com                    9123333331

P               Q                    R                    c1@gmail.com                   9123333332

A               R                    Y                    r1@gmail.com                    9123333336

A               T                    Z                    t1@gmail.com                    9123333335

BR_Code remains constant but other details keeps changing (in a day or two).

Recipient Schema has customer email id & @text1 field of recipient  table has BR_Code so that it can be mapped with brData .

When I query Targeting dimension as Recipient & Filtering Dimension as brData and condition as BR_Code = 'A',it returns all customers in Recipient table with BR_Code as A but when I try to personalize BR_Manager_Name or BR_Manager_EMAIL_ID or BR_Manager_Phone# 

it returns undefined.

The syntax I have used in delivery to personalize is <%= recipient.brdata_Recipient.BR_Manager_Name %>.

When I use <%= recipient.text1 %> for Branch Code, it works perfectly fine but <%= recipient.brdata_Recipient.BR_Manager_Name %> is not working.

What I am missing here?

View Entire Topic

Avatar

Avatar

ckumari12

Avatar

ckumari12

ckumari12

03-08-2017

Hi Ankur,

BR_data schema is a table storing master branch codes( BR_Code).

BR_Code  BR_Name BR_Manager_Name  BR_Manager_EMAIL_ID     BR_Manager_Phone#

A               B                    C                    a1@gmail.com                   9123333333

X               Y                    Z                    b1@gmail.com                    9123333331

P               Q                    R                    c1@gmail.com                   9123333332

Multiple recipients can have same BR_Code.

I am storing BR_Code in text1 field of recipient table.

In br_Data schema, I have created Join as below:

    <element externalJoin="true" label="Recipient" name="recipient" target="nms:recipient"

             type="link">

      <join xpath-dst="@text1" xpath-src="@brCode"/>

    </element>

    <key internal="true" name="brDetailsKey">

      <keyfield xpath="@brCode"/>

    </key>

Using enrichment, I am able to personalize the delivery. I am looking to do it directly through br_Data table in the delivery for the sake of simplicity.

I can make changes in br_Data schema if this is limiting me in anyway in directly personalizing the delivery.

Thanks,

Chandni