Recipient Information Field Reference

You can reference the recipient information fields in expressions and SQL queries, since they are self-generated variables.

Syntax:

|->[Field] returns the selected Recipient Information field that was defined in the Recipient Information schema section of the plan.

You can also write the name without the square brackets, provided that the name starts with a letter and contains only alphanumeric characters.

You can use the character "?" to reference a special variable, which is the primary field (XMPieRecipientKey) in the Recipient Information schema.

Example:

SELECT AccountId FROM Accounts WHERE CustomerId = ?;