SOQL: Accessing the Contact Owner Field

Question

Hello,

Im trying to write a SOQL query that will grab one of the Contact object's standard fields "Contact Owner", which is a Lookup(User) field.

The field name is "Owner", but when I try to query

SELECT Contact.Owner FROM Contact

I get an error stating that there is no such field.

How can I grab this field?

Thank you!

Deepak Balur · Accepted Answer

Select c.Owner.Email,  c.Owner.Name , c.Owner.Username, c.OwnerId From Contact c Run the above in Developer Console--Query Editor

Deepak Balur · Answer

c is just a table alias. "c.Owner" does not exist as a field in Contacts instead it's Id is stored in the OwnerId field and hencer we need to use c.OwnerId.

SOQL: Accessing the Contact Owner Field

Salesforce Developer

Formation associée

Aide supplémentaire