Apex Code Development You need to sign in to do that
Don't have an account?
SOQL join for Case and User object
I want to retrieve CompanyName of a Case Owner . I am using below query but not working .
Select c.Owner.Email, c.Owner.CompanyName, c.Owner.Name, c.ClosedDate, c.CaseNumber From Case c where c.CaseNumber='1002'
if i remove c.Owner.CompanyName from query then it is working fine.
So how can i retrieve Company name of case Owner along with CaseNumber and case ClosedDate in a single Query.
Select c.Owner.Email, c.Owner.CompanyName, c.Owner.Name, c.ClosedDate, c.CaseNumber From Case c where c.CaseNumber='1002'
if i remove c.Owner.CompanyName from query then it is working fine.
So how can i retrieve Company name of case Owner along with CaseNumber and case ClosedDate in a single Query.
If CompanyName is custom field on User object then you need to use __c at the end of field name i.e. complete API name