Skip to main content

Trying to create a custom object change log:

  1. The tracking object must contain the following fields:

    1. Account 
    2. Auto-generated sequential number
    3. Name of the field that changed (Account Name, Affilated Company, or Parent Account).
    4. The old value of the field.
    5. The new value of the field.
    6. The date/time the old value has been assigned.
    7. The date/time the new value has been replaced.
  2. We seed the tracking records for each account, and each of the three tracked fields:

    1. Account ID
    2. Name of the filed = AccountName or FamilyName or ParentName
    3. Old value = blank
    4. Date/time assigned 1900-01-01 00:00
    5. New value = existing AccountName or FamilyName or ParentName
    6. Date/time expired = 9999-01-01 00:00
    7. Note that initial record will have the fake assigned date, e.g., 1900-01-01 for initial records, and fake expiration for non-expired, eg 9999-01-01 00:00.

The first few fields already exsist it really is the last 2 fields that I am having problems with - creating the fake expiration date

 

Something like below

 

 

event_id account_id field previous_value new_value effective_timestamp 1 0013D00000ZbXodQAF TextName abc ABC 1900-01-01 00:00:00 2 0013D00000ZbXodQAF TextName ABC abc 2018-08-15 16:55:11 3 0013D00000ZbXodQAF TextName abc ABC 2018-08-21 14:55:45

 

Looking for any thoughts on how to achieve this.

 

Thanks 

 

John
답변 1개
0/9000