You need to sign in to do that
Don't have an account?
Karthik 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.
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.
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.
Please check for all these fields , if field level security is there for the profile with which you are trying to query the fields.