Skip to main content
Topics#Salesforce DeveloperSimon Lafont's Question
Simon Lafont (Sofacto) asked in #Salesforce Developer
Apr 15, 2020, 12:46 PM

Retrieve logged as soql history

Hi everyone,

I work for an ISV and sometimes the customer make some data modification as I'm working on his org.

All modification are written as done by the user I'm logged with so it's impossible afterwards to know if I did the modification or him.

Is there any way through SOQL to retrieve who really did the modificaition ?

I use this kind of SOQL from this article (https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_relationships_query_hist.htm

) :

SELECT OldValue, NewValue, Parent.Id, Parent.name, Parent.customfield__c 
FROM foo__history

I'm looking for, if it's possible, the right field to put in select to retrive this information.
2 answers
  1. Swetha Maddali (Salesforce)
    Apr 15, 2020, 1:18 PM
    HI Simon,

    Using Setup audit trail we can check any changes made to the set up, password reset and also find who has logged as which user, Using the debug logs we can see, what modifications are made on a record, However we cannot differentiate who has made the change ( Logged in user or the user himself) . I believe there is no other way to identify changes made.

     

    Hope this helps you. Please mark this answer as best so that others facing the

    same issue will find this information useful.

     

    Thank you
Write an answer...
0/9000