LookupProductIdByName
The LookupProductIdByName function returns the xactly.xc_product.product_id value for the given string input parameter.
Syntax
LookupProductIdByName(<string>) |
Return Type
Long
Details
The function returns null if the input parameter does not match a name in the xactly.xc_product table.
Examples
eval LookupProductIdByName('Monitor');
select product_name, LookupProductIdByName(product_name), count(*) from staging.order_item;
