GetLookupListValueWithClientID
 | Note: This function is available for use in sub-tenancy environments only.
|
Syntax: GetLookupListValueWithClientID(TableName, Key, ClientID, KeyValue)
Arguments:
- TableName is the lookup table name.
- Key is the key to look up in the table.
- ClientID is the client ID from the transaction data
- KeyValue is the string that will hold the extracted key value.
Return Type: Integer
1: Success
0: Key does not exist
-1: If the function returns an error. For example, when the List table does not exist, or when no List data has been loaded.
Description: Looks up the Key in the TableName, and sets Value to the extracted value for a specific ClientID.
Example:
toDate is a string;
fromDate is a string;
value is a string;
clientId is a string;
serviceId is a string;
serviceId = Left(CRTRAN24.pan, 16);
if ( GetLookupListValueWithClientID("FREQUENT TRAVELERS", serviceId, CRTRAN24.clientIdFromHeader, value) = 1 ) then {
fromDate = Mid(value, 0, 8);
toDate = Mid(value, 8, 16);
if (Date_Convert(CRTRAN24.transactionDate) >= Date_Convert(fromDate) and
Date_Convert(CRTRAN24.transactionDate) <= Date_Convert(toDate)) then {
SuppressCase(SERVICE);
}
}