Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

DCE - Select related recipient fields

campaignap
Level 2
Level 2

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
dloyd
Correct answer by
Level 4
Level 4

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
dloyd
Correct answer by
Level 4
Level 4

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...