> 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 custom field definition changes

> Learn how to retrieve auditing records of changes to custom field definitions using a data query.

Learn how to retrieve auditing records of changes to custom field definitions using a data query.

The following use case retrieves the auditing records of changes to custom field definitions.

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,
       objectname  AS ObjectName,
       attributeid AS Attribute,
       oldvalue    AS OldValue,
       newvalue    AS NewValue,
       timestamp   AS Timestamp
FROM   auditobjectchangeevent
WHERE  objecttype = 'CustomFieldDefinition'
       AND year = 2022
       AND month = 11
       AND day > 1
       AND day < 31
ORDER  BY timestamp DESC 
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,ObjectName,Attribute,OldValue,NewValue,Timestamp
audit-trail@zuora.com,UPDATED,Account.LastReviewDate__c,Required,true,false,2022-11-13T07:50:44.683Z
audit-trail@zuora.com,CREATED,Account.LastReviewDate__c,Description,,Date of the last business review with the customer,2022-11-13T07:50:22.915Z
audit-trail@zuora.com,CREATED,Account.LastReviewDate__c,ApiName,,LastReviewDate__c,2022-11-13T07:50:22.915Z
audit-trail@zuora.com,CREATED,Account.LastReviewDate__c,Required,,true,2022-11-13T07:50:22.915Z
audit-trail@zuora.com,CREATED,Account.LastReviewDate__c,ReadOnlyOnUI,,false,2022-11-13T07:50:22.915Z
audit-trail@zuora.com,CREATED,Account.LastReviewDate__c,Type,,Date,2022-11-13T07:50:22.915Z
audit-trail@zuora.com,CREATED,Account.LastReviewDate__c,Label,,LastReviewDate,2022-11-13T07:50:22.915Z
audit-trail@zuora.com,CREATED,Account.LastReviewDate__c,MaxLength,,255,2022-11-13T07:50:22.915Z
```