Email Addresses and Phone Numbers as Separate SELECT Values in a ROQL Query
We are trying to get the individual phone numbers and email addresses included as separate values in a ROQL SELECT statement, along with other contact fields, in the same returned contact record.
In theory, using the database field names from the data dictionary, the query would look something like this:
SELECT C.ID, C.email, C.email_alt1, C.email_alt2, C.ph_fax, C.ph_home, C.ph_office, C.ph_mobile, C.ph_asst FROM Contact C
The ROQL documentation shows that the individual phone numbers and email addresses are returned as list values and not as separate fields, which implies that what we are looking to do is not possible. Is there another way to accomplish this that we're not considering?