MENU
A developer wants to retrieve all recordsin the OrderDetails data extension which are associated with a particular customer.
Which two AMPscript functions would return a suitable rowset?
Choose 2 answers
To retrieve multiple records associated with a particular customer from the OrderDetails data extension, the LookupRows and LookupOrderedRows functions are suitable. These functions return a rowset containing the records that match the specified criteria.
LookupRows: Retrieves a rowset of records based on specified criteria.
Example:
ampscript
Copy code
SET @rows = LookupRows('OrderDetails', 'CustomerID', @customerID)
LookupOrderedRows: Retrieves a rowset of records based on specified criteria and allows for sorting.
Example:
SET @rows = LookupOrderedRows('OrderDetails', 0, 'OrderDate DESC', 'CustomerID', @customerID)
: Salesforce AMPscript LookupRows