Audit
The Audit view.
Table Specific Information
Select
When querying Audit, you can get Audit logs 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'
Columns
| Name | Type | Description |
| Parent_Id | String | |
| Date_Created | Datetime | |
| Created_By | String | |
| Created_By_Username | String | |
| Field_Name | String | |
| Data_Type | String | |
| Before_Value_String | String | |
| After_Value_String | String | |
| Before | String | |
| After | String |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Module | String |