LookupCustomerIdByName
Summary
The LookupCustomerIdByName function returns the xactly.xc_customer.customer_id value for the given string input parameter.
Syntax
LookupCustomerIdByName(<string>) |
Return Type
Long
Details
The function returns null if the input parameter does not match a name in the xactly.xc_customer table.
Examples
eval LookupCustomerIdByName(‘Oceanic Airlines’);
select customer_name,
LookupCustomerIdByName(customer_name),
count(*)
from staging.order_item;
Related Functions