> This page is for Docs.

> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://zuora.ferndocs.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://zuora.ferndocs.com/_mcp/server.

# Retrieve Order changes

> This task guides you through retrieving auditing records of changes to order changes using a data query.

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](/docs/platform/data/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](https://www.zuora.com/developer/api-references/api/operation/GET_DataQueryJob) 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
```