+ Start a Discussion
Zaid Farooqi 7Zaid Farooqi 7 

Finding the SOQL query


how can I find out what the associated SOQL query is to a field in SFDC. For example if I want to know what the SOQL query for an account field named 'Account Name' is?
Bryan Leaman 6Bryan Leaman 6
To find the actual field developer name to use in a SOQL query, go to the fields section of the object definition and search for the field label.

In lightning: Go to Setup | Object Manager, key in the object label ("Account"), click on the "Account" object name, click on "Fields & Relationships" and then key in all or part of the field label. Both the field label and the field name are shown on-screen.

Find Account name field in lightning

In classic for standard objects (like Account): Go to "Setup | Customize | {object name, like "Account"} | Fields" 
In classic for custom and managed objects: Go to "Setup | Create | Object", search for your object label and click on it. Search in the "Standard Fields" and "Custom Fields & Relationships" sections.

Account field names

There are also some Chrome extensions that can give you access to this information from a record page, like "Salesforce inspector".
Use workbench (https://workbench.developerforce.com" target="_blank) >> SOQL Query option. This lists you all the fields as you choose an object.

Hope this helps.

Deepali KulshresthaDeepali Kulshrestha

Hi Zaid,

I have gone through your problem please refer bellow code:

Apex Class:

public class TestAccount {
    public static void testAccount(){
        List<Account> laccount=[select Id,Name from Account];

In this code, you can find Account Name.
You can also use any object API name and find the related field.

You can also refer below link:


I hope you find the above solution helpful. If it does, please mark as Best Answer to help others too.

Thanks and Regards,
Deepali Kulshrestha