LookupBatchTypeNameByBatchName
The LookupBatchTypeNameByBatchName function takes a batch name input parameter and returns the corresponding xactly.xc_batch_type.name. The batch name input parameter should match a value in xactly.xc_user_batch.name.
Syntax
LookupBatchTypeNameByBatchName(<string>) |
Return Type
string
Details
Null is returned if the function cannot find a matching value in xactly.xc_batch_type.name for a row in xactly.xc_user_batch.batch_name.
Examples
eval LookupBatchTypeNameByBatchName(‘March Orders 2016’);
select batch_id,
batch_name,
LookupBatchTypeNameByBatchName(batch_name)
from xactly.xc_user_batch;
