Expand my Community achievements bar.

SOLVED

DCE - Select related recipient fields

Avatar

Level 3

Using the DCE, how can we select other fields related to the recipient from the expression editor? It seems only OOTB tables are visible e.g Location, Postal address, Country/Region etc.

 

dce.PNG

 

Related tables

dceFooter.PNG

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

The DCE is somewhat limited. If you are building an email, then you would want to make sure you have enriched all your data in the workflow from other tables. Then can you use <%= targetData.columnName %> to pull in data from the workflow. If you are building a web page you need to run a query as your first step (in XML) then add it to the CTX web variable, to be able to use it in a web page.

web app: https://blog.floriancourgey.com/2018/07/use-the-context-in-web-apps-in-adobe-campaign

emails: https://experienceleague.adobe.com/docs/campaign-classic/using/sending-messages/sending-emails/defin...

View solution in original post

1 Reply

Avatar

Correct answer by
Employee Advisor

The DCE is somewhat limited. If you are building an email, then you would want to make sure you have enriched all your data in the workflow from other tables. Then can you use <%= targetData.columnName %> to pull in data from the workflow. If you are building a web page you need to run a query as your first step (in XML) then add it to the CTX web variable, to be able to use it in a web page.

web app: https://blog.floriancourgey.com/2018/07/use-the-context-in-web-apps-in-adobe-campaign

emails: https://experienceleague.adobe.com/docs/campaign-classic/using/sending-messages/sending-emails/defin...