6

I am looking to find the "Custom" fields that were created "today" within an object in Salesforce.com. There are more than 500 fields on the object and the "Modified By" field in the schema is not sortable.

Object can be Standard or Custom.

10

Interestingly enough, I discovered this yesterday. Open your Developer Console, click on the Query Editor tab, click the "Use Tooling API" checkbox, then query away!

SELECT DeveloperName, TableEnumOrId FROM CustomField WHERE CreatedDate = TODAY

If you want to limit it to a single table, you can also filter by TableEnumOrId:

Standard Object

SELECT DeveloperName, TableEnumOrId FROM CustomField WHERE CreatedDate = TODAY AND TableEnumOrId = 'Account'

Custom Object

SELECT DeveloperName, TableEnumOrId FROM CustomField WHERE CreatedDate = TODAY AND TableEnumOrId = '01I...'

WHere 01I... is the Id of the custom object, which you can get from the following query:

SELECT Id, DeveloperName FROM CustomObject WHERE DeveloperName = 'CustomObj'

Note that DeveloperName in the Tooling API never uses __c.

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.