Acessing 1:n data from DB in a Campaign Delivery

Avatar

Avatar

Bruno_Cotrim

Avatar

Bruno_Cotrim

Bruno_Cotrim

27-02-2019

Good morning,


I've been having a hard time since yesterday because I can't access the data that is in a one to many table in the database.Adobe problem.JPG

This is the case, I want to send a e-mail to an Employee, using data from one of the month and all the flights of that month.

So far I've not been able to find the data in a test preview as seen in the next images.

The code:

Adobe problem code.JPG

The result preview:

Adobe problem output.JPG

The data that I've found is the value of an external key (Unique Flight) in the employeeFlights Table.

Is it possible to access the full scope of data in the employeeFlights table to create a dynamic template that shows as many flights as there is entries in the table?

Note that the target mapping points to the Employees table not the Months table.

View Entire Topic

Avatar

Avatar

Bruno_Cotrim

Avatar

Bruno_Cotrim

Bruno_Cotrim

27-02-2019

I've found a way to do it the way I was expecting to do it.


Thank you