function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Karthik jKarthik j 

Not able to query Account fields.

Hi
I am trying to query some fields of Account in query editor. 
select id,Alternate_Number_1__c,
            Alternate_Number_2__c,
            Alternate_Number_3__c,
            Phone,Student_Phone_Number__c
            from 
            Account 
I cross checked  in object manager and all these fields are there in account object. but I am getting this error.
select id,Alternate_Number_1__c,
          ^
ERROR at Row:1:Column:11
No such column 'Alternate_Number_1__c' on entity 'Account'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names.

FYI  all these fields are there in Person Account records.
Priyesh Misquith 12Priyesh Misquith 12
Hi Karthik j

try to build your query with https://dataloader.io/ or https://workbench.developerforce.com/login.php it will show you list of fields

In dataloader follow once you login click on the newtask --> Expot --> select object (Account)--> select the fields that you require in the query editor --> click verify button to verify the query.  later use this query in your query editor.
User-added image
 
Mohita KalraMohita Kalra
Hi Karthik,

Please check for all these fields , if field level security is there for the profile with which you are trying to query the fields.