How to get Email from Task object record using SOQL

salesforce soql
Andrew Jackman picture Andrew Jackman · Feb 4, 2013 · Viewed 7.7k times · Source

I am trying to get the Contact/Lead email from the Task object using SOQL (I am creating an interface in PHP to back up messages with a specific subject). Here is my query right now:

SELECT Subject,Who.FirstName,Who.LastName,Who.Email,Who.Phone,Description FROM Task

This works/doesn't throw an error and gives me results, but Who.Email is always empty (and, coincidentally Who.Phone is as well, but it is not very important for this). If I try just using Email I get an error that the field doesn't exist, which is weird because Email is under Task Fields as a standard field.

I have also tried several google searches with no sort of assistance found.

Answer

amrcn_werewolf picture amrcn_werewolf · Feb 4, 2013

Because the WhoId and WhatId fields of Task are polymorphic (i.e. can point to many different kinds of objects) you can't just query relationships through them like you can for normally-related objects. Instead, you'll have to do 2 SOQL queries, the first to get the Task information and the second to get the info from the Contact or Lead that the Who is pointing to.

Related questions

SOQL query WHERE Date = 30_days_ago?

How do I make a SOQL query like this? SELECT id FROM Account WHERE LastActivityDate = 30_DAYS_AGO This produces an error: MALFORMED_QUERY: Account WHERE LastActivityDate = 30_DAYS_AGO ^

Read More
SOQL query with subquery

I'm having trouble getting the results I want from a Salesforce/Apex/SOQL query. I want: A list of Contact objects containing only contacts who are CampaignMembers of a set of campaigns; and they should have the data from that …

Read More
salesforce SOQL : query to fetch all the fields on the entity

I was going through the SOQL documentation , but couldn't find query to fetch all the field data of an entity say , Account , like select * from Account [ SQL syntax ] Is there a syntax like the above in SOQL to fetch all …

Read More