You need to sign in to do that
Don't have an account?
Glenn Nyhan 91
SOQL Script Issue
I've created a SOQL script connected to the School object and it runs fine with these criteria -SELECT Name, Country__c, School_Id__c, Teachers__c FROM School__c ORDER BY Country__c ASC
But, when I add other additional criteria from the object i.e. District__c : SELECT Name, Country__c, School_Id__c, Teachers__c, District__c FROM School__c ORDER BY Country__c ASC
I get the following error message:
INVALID_FIELD Country__c, School_Id__c, Teachers__c, District__c
^
ERROR at Row:1:Column:53
No such column 'District__c' on entity 'School__c'. 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. Global School Name Query 8 All Schools Info.soql
Does this mean the field District_c is on another object? Thanks for any help.
But, when I add other additional criteria from the object i.e. District__c : SELECT Name, Country__c, School_Id__c, Teachers__c, District__c FROM School__c ORDER BY Country__c ASC
I get the following error message:
INVALID_FIELD Country__c, School_Id__c, Teachers__c, District__c
^
ERROR at Row:1:Column:53
No such column 'District__c' on entity 'School__c'. 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. Global School Name Query 8 All Schools Info.soql
Does this mean the field District_c is on another object? Thanks for any help.
It simply means that the District__c field is not in the School__c object. Yes it can be in another object and if it is in the School__c object please, check its API name.
Please mark it as Best Answer if it helps you.
Thanks & Regards
Suraj Tripathi