Create, update, delete, and query the Audit module in SugarCRM.
Table Specific Information
When querying Audit you can get Audit logs simply by specifying the Module name (this is required):
SELECT * FROM Audit WHERE Module = 'Contacts'
Allowed values for Module are: Accounts, KBDocuments, RevenueLineItems, Contacts, Opportunities, Leads
If you want to get Audit logs for a single Module Id, the Audit parent_id needs to be tied to the ID that belongs to the module, for instance:
SELECT * FROM Audit WHERE Module = 'Contacts' AND parent_id = '9d46a91c-43bf-11e8-a83c-0681183120c1'
|Parent_Id||String||The Id of the parent of the record.|
|Date_Created||Datetime||The date the record was created.|
|Created_By||String||The Id of the user who created the record.|
|Created_By_Username||String||The user who created the record.|
|Field_Name||String||The field name of the record.|
|Data_Type||String||The data type of the record.|
|Before_Value_String||String||The before value of the record.|
|After_Value_String||String||The after value of the record.|
|Before||String||The before value of the record.|
|After||String||The after value of the record.|