3

Is there a way to get the billing or shipping address in account object as a single data? Currently the address data is split across several fields like

Street Address
City
State
Zip
Country

Is there any field called "BillingAddress" exists? Please suggest.

Improve this question
1
  • Hi, I work on this. Out of curiosity, what is your use case such that querying the individual columns doesn't fit your needs?
    – Carolyn Grabill
    Commented Aug 25, 2014 at 19:24

1 Answer 1

Reset to default
5

https://www.salesforce.com/us/developer/docs/api/Content/compound_fields_address.htm

After v30 Sfdc introduced compound field.This is read only field which is available on Account object

A sample SOQL will be as below

SELECT Name, BillingAddress FROM Account

Improve this answer
2
  • Thanks Mohith. I checked in salesforce.schema in eclipse IDE and did not find it. But now as per your suggestion it is working fine for me.
    – Bforce
    Commented Aug 24, 2014 at 19:37
  • is there any field type in a standard or custom object to persists BillingAddress data. when i assigned the billingaddress data to a text field it throws error. Any suggestions pls
    – Bforce
    Commented Aug 28, 2014 at 19:09

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .