You need to sign in to do that
Don't have an account?
Beatriz Minguez
Contact.PostalCode
Regarding using SOQL to assign and retrieve attributes, I need identify the Postal Code of the Contact and I do not know how to name it?
Imagine I am having the following code:
Contact[] cts = [SELECT Contact.LastName, Contact.Postal_Code FROM Contact WHERE LastName =: sName OR PostalCode =: sPostalCode];
System.debug('Last Name forund + cts[0].LastName);
System.debug('PostalCode found' + cts[0].PostalCode);
The problem is that Contact.PostalCode can't be found and I do not know how to name it.
Anyone can help me?
Thanks!
Bea
Imagine I am having the following code:
Contact[] cts = [SELECT Contact.LastName, Contact.Postal_Code FROM Contact WHERE LastName =: sName OR PostalCode =: sPostalCode];
System.debug('Last Name forund + cts[0].LastName);
System.debug('PostalCode found' + cts[0].PostalCode);
The problem is that Contact.PostalCode can't be found and I do not know how to name it.
Anyone can help me?
Thanks!
Bea
The field name for the PostalCode is MailingPostalCode
So your SOQL will be All the address fields on Contact start as Mailing, so its MailingStreet, MailingCity, MailingState, MailingCountry, MailingPostalCode
Thank you
All Answers
The field name for the PostalCode is MailingPostalCode
So your SOQL will be All the address fields on Contact start as Mailing, so its MailingStreet, MailingCity, MailingState, MailingCountry, MailingPostalCode
Thank you
Is there any documentation where I can look for the name of the fields?
I think this pdf is what you are looking for :)
http://resources.docs.salesforce.com/198/16/en-us/sfdc/pdf/salesforce_field_names_reference.pdf
Regards
Is there some place on Developer or something where I can check the current Object Fields and their Column level mappings?