Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Walter@AdicioWalter@Adicio 

Why does this value in a query not work CreatedBy.Any_Field

 

I am confused please help me understand. Why does the Salesforce Schema in the Eclipse IDE allow you to built a query that may look like this...

 

 

Select c.ParentId, c.CreatedDate, c.CreatedBy.PortalRole, c.CreatedBy.SuperUser, c.CreatedBy.Id, c.CreatedById, c.CommentBody From CaseComment c where (c.CreatedBy.SuperUser = true)

 

And every single field I try for CreatedBy does not work. For example

 

CreatedBy.SuperUser

 

None of them work except CreatedBy.Id.

 

All of them give me this error...

 

"No such column "SuperUser" on entity "Name".

 

I understand CreatedBy is returning a Name, but how come the relationship the schema allows me to build does not work?

 

I know it is just that I am miss understanding. Please help me understand.

 

Thank you.