LookupList
Syntax: LookupList(string TableName, string Key)
Arguments:
- TableName is a string that contains the name of a List table at the tenant level. This is opposed to the GlobalLookupList function that is used across tenants.
- Key is a string that contains a value to find in the table, such as an account number or zip code. In a hotlist, this is the first column in the list. By default in the Case Manager, this is called the Name column.
Return Type: Integer
- 1 if Key is found in the List table
- 0 if it is not
- -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: Searches for a value in a list lookup table. To use this function, the List feature must be enabled in the environment and some List data must have been loaded.
 | Note: LookupList() replaces the obsolete function,
Lookup().
|
You use Lookup functions to check or maintain a site-specific list of data. This could be countries with a higher risk of fraud, compromised account numbers, or Merchant IDs where fraud has occurred in the past. The value in the table is compared against incoming transactions data. The LookupList function is primarily used as the condition of a rule. If the value from the incoming transaction matches a value on the list, the condition is met.
 | Important: If you create a rule to see if a value is in a list, the rule should explicitly look for a return value of “1”. See the examples below.
|
Examples:
if (LookupList("RISKY_COUNTRIES", CRTRAN24.merchantCountrycode) = 1
and ffmCardScore.Score >= 750 )
then {TriggerCase(ACCOUNT);
}In this example, if the transaction's country is on the RISKY_COUNTRIES list and the transactions received a score of 750 or higher, a case will be created.
if (LookupList("RISKY_COUNTRIES",
concat(CRTRAN24.merchantCountryCode,
concat("_", CRTRAN24.clientIdFromHeader))) = 1
and ffmCardScore.Score >= 750 ) then {
TriggerCase(ACCOUNT);
}