function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

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




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.