when I get data from AccountHistory, including "deleted and archived records", I get all my tracking history. The problem is that the column Id doesn't match any id in my org.

For example, these two lines are the same:

001b000003VxlznAAB 005b0000000dO5vAAE 2018-12-13T16:03:17.000Z RIR_Status__c 0170N0000uA7CJLQA3 false

Toto CF 13/12/2018 17:03 Changed RIR Status from KYC to be regularized to KYC to be completed.

Where can I translate the id 0170N0000uA7CJLQA3 ? Here is the query:

SELECT AccountId,CreatedById,CreatedDate,Field,Id,IsDeleted,NewValue,OldValue FROM AccountHistory WHERE AccountId = '001b000003VxlznAAB' ORDER BY CreatedDate ASC NULLS FIRST
  • 1
    Your question is a bit hard to understand. Are you saying there is no AccountHistory record in your org with the Id 0170N0000uA7CJLQA3? Or no Account record with the Id 001b000003VxlznAAB ? Or...something else? – Adrian Larson Dec 21 '18 at 15:36
  • I have data in AccountHistory with AccountIds which are in my org. But, the column Id contains Id that I can't see. In my example, I guess that 0170N0000uA7CJLQA3 should be the Id which means "Changed RIR Status from KYC to be regularized to KYC to be completed" which are data in a picklist. How can I get the mapping for all Ids? Because I have more history that are no more available in Salesforce and I don't know what the ids mean. Is it clearer? – CoF Dec 24 '18 at 9:32

Same as any SFDC object, the column "Id" of AccountHistory refers to the recordId of that particular AccountHistory record...

AccountId refers to the particular Account record being modified

OldValue and NewValue columns stores the "Old Value" and "New Value" - in your case, the picklist value changes

AccountHistory Object Reference

  • Thanks for your answer. The question is how can I get the label of this recordId? – CoF Dec 27 '18 at 9:28
  • Label of what? Field label of RIR_Status__c or Picklist value label? – Kaon Z Dec 27 '18 at 10:25
  • You said that the Id is the recordId of one particular AccountHistory record. I'd like to have the label/description of thid particular record because the Id means nothing. Where/how can I find this info? – CoF Dec 28 '18 at 13:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.