LookupListUpdateEntryWithDTTMAndClientID

Note: This function is available for use in sub-tenancy environments only.

Syntax: LookupListUpdateEntryWithDTTMAndClientID(TableName, Key, Value, Comment, StartActiveDTTM, EndActiveDTTM, ClientID)

Arguments:

  • TableName is the Lookup List table name.
  • Key is the key column in the table.
  • Value is the value for that Key.
  • Comment is the string value for comment. The number of available characters for the Comments argument is limited to 66 characters.
  • The start time StartActiveDTTM through to the end time EndActiveDTTM defines the period of time for updating List lookup entries.
  • ClientID is the client ID from the transaction data.

The DTTM value is in the ccyymmddhhmmss format where ccyy is the year, mm is the month, dd is the day, hh is the hour, mm is minutes, and ss is seconds. A DateTimeValue of "20170102105033" represents January 2, 2017 10:50am and 33 seconds.

Return Type: Integer

1: If it fails.

0: If it is successful.

-1: If there are more than 32 add, update, or remove operations per transaction.

-2: If the record size exceeds the maximum record size (currently 1024 characters).

Description: Updates a List lookup entry in the List table at the sub-tenant level. This function is at the sub-tenant level instead of global level.

Examples:
retCode is an integer;
Key is a string initially CRTRAN24.pan;
Value is a string initially “Pin”;
Comment is a string initially "Restrict Pin";
StartActiveDTTM is a string initially "20171101122546";
EndActiveDTTM is a string initially "20171130122546";
ClientID is a string initially CRTRAN24.clientIdFromHeader;
print("\r\n");
retCode = LookupListUpdateEntryWithDTTMAndClientID(SYSTEM_RESTRICT, Key, Value, Comment, StartActiveDTTM, EndActiveDTTM, ClientID);
  • www.fico.com