Retrieve Order changes
This task guides you through retrieving auditing records of changes to order changes using a data query.
The following use case retrieves the auditing records of Order Changes.
- Submit a data query job through UI or API with the following SQL query:
SELECT username AS Username, action AS Action, objecttype AS ObjectType, objectname AS ObjectName, attributeid AS Attribute, oldvalue AS OldValue, newvalue AS NewValue, timestamp AS Timestamp FROM auditobjectchangeevent WHERE objecttype = 'Orders' AND year = 2025 AND month = 12 ORDER BY timestamp DESC, transactionid LIMIT 100000 - Check the status of the query job through UI or Get data query job API operation.
- Download the query result when the job is completed. See the following example of the query result.
Username,Action,ObjectType,ObjectName,Attribute,OldValue,NewValue,Timestamp user@company.com,CREATED,Orders,O-00183168,readonly__c,,1,2025-12-10T09:32:44Z user@company.com,CREATED,Orders,O-00183168,HardwarePaymentReservation__c,,Wire transfer payment received,2025-12-10T09:32:44Z user@company.com,CREATED,Orders,O-00183168,HardwarePaymentReservation__c_old__c,,Wire transfer payment received,2025-12-10T09:32:44Z user@company.com,CREATED,Orders,O-00183168,Status,,Pending,2025-12-10T09:32:44Z user@company.com,CREATED,Orders,O-00183168,AccountId,,2c92c0f85e5e7d4f015e5f5b50ff0634,2025-12-10T09:32:44Z user@company.com,CREATED,Orders,O-00183168,OrderNumber,,O-00183168,2025-12-10T09:32:44Z user@company.com,CREATED,Orders,O-00183168,OrderDate,,2025-12-10,2025-12-10T09:32:44Z user@company.com,CREATED,Orders,O-00183168,ReversionOrder,,false,2025-12-10T09:32:44Z user@company.com,CREATED,Orders,O-00183168,Id,,86d4836bb519b07908eb079b1d9b0000,2025-12-10T09:32:44Z user@company.com,CREATED,Orders,O-00183168,State,,Executing,2025-12-10T09:32:44Z