ODBC Driver for SugarCRM

Build 24.0.9062

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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
Module String

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062