Apex Code Development You need to sign in to do that
Don't have an account?
jagdish nikam 9 Access Custom field in SOQL query
Hi All,
Could you please tell me how can I access custom field in SOQL query?
I have custom field amount in standerd object contact and i have written SOQL query List<contact> acc = [select Id, name, amount__c from contact]; but it doesn't work.
Please help!!!
Could you please tell me how can I access custom field in SOQL query?
I have custom field amount in standerd object contact and i have written SOQL query List<contact> acc = [select Id, name, amount__c from contact]; but it doesn't work.
Please help!!!
your query is look good , for access custom fields we are use __c after field name so
what error you are getting ?
* make sure you have data in amount field
* make sure give permission to custom field
thanks
I used amount__c as a currency field and it's work perfectly for me.
Try this :
List<contact> acc = [select Id, name, amount__c from contact where amount__c > 0]; for(contact c : acc) { System.debug('ID : '+c.id+' Name : '+c.name+' Amount : '+c.amount__c ); }Regards,Ajay