LookupListWithClientID
 | Note: This function is available for use in sub-tenancy environments only.
|
Syntax: LookupListWithClientID(string TableName, string Key, string ClientID)
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.
- ClientID is the client ID from the transaction data.
Return Type: Integer
- 1: If Key is found in the List table.
- 0: If Key is not found in the List table.
- -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 based on ClientID. To use this function, the lookup list (hotlist) feature must be enabled, and some lookup list data must have been loaded.
 | 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 (LookupListWithClientID("RISKY_COUNTRIES", CRTRAN24.merchantCountrycode, CRTRAN24.clientIdFromHeader) = 1
and ffmCardScore.Score >= 750 )
then {TriggerCase(ACCOUNT);
}