Use enumeration label instead of value in email delivery

Question

Hello, I'm trying to use the enumeration label in a delivery instead of the internal value in an email delivery. I would like to know how to do it.

I've already tried with exportFormat/analyze="true", but I think it only works for deliveries that generate a file.

How should I do this for the email delivery?

Thank you in advance.

ccg1706 · Accepted Answer

Hi @heku_,

Sorry that was a mistake by my side, the NLWS is supported in Adobe Campaign Standard.

You can try to use queryDef to retrieve the label for a specific enumeration value that comes from the xtk: enumValue schema.

A solution as a guidance:

var enumSchema = "EnumSchema"; 
var enumValue = "fieldtouse";  

var queryDef = `<queryDef schema="xtk:enumValue">
                   <select>
                      <node expr="@label" alias="label"/>
                   </select>
                   <where>
                      <condition expr="@name='${enumSchema}'"/>
                      <condition expr="@value='${enumValue}'"/>
                   </where>
                </queryDef>`;

try {
   var query = xtk.queryDef.create(queryDef);
   var result = query.ExecuteQuery();

   if (result.length > 0) {
      var label = result[0].label;
      logInfo("Label: " + label);
   } else {
      logError("No label found.");
   }
} catch (e) {
   logError("Error: " + e.message);
}

** Replace "EnumSchema" with your enum schema name
** Replace "fieldtouse" with the enum value you need

Finally I leave you with some documentation links:

Adobe API JS

queryDef

Regards,

Celia

ccg1706 · Answer

Hi @heku_,

I share with you some useful documentation links that can help you to solve your issue:

Managing enumerations

Comfiguring export jobs

JavaScript scripts and templates

Some solutions that come to my mind, that you can try are:

-Create a custom function inside a JavaScript Activity, before the delivery to transform the enumeration value into it's label. Store the label in a temporary field in order to use it in the delivery.

-Create a content block where you use JavaScript to retreive and display the enumeration. I share with you a possible solution as a guidance.

<%=NLWS.nmsEnum.getLabel("EnumSchema", fieldtouse) %>
*Inside EnumSchema, insert the schema name for the enumeration
*Inside field to use put the field you want to use

Regards,

Celia

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded