I am struggling with the createdby reference and hope someone could help me out. I have a custom object and as everyone knows there is a standard createdbyId created on every custom object. We can use Createdby.Name to get the the name of the creator. I have created a custom picklist field Type__c on standard user object and want to use Createdby.Type__c to get the user type info.However I got the error "No such column 'Type__c' on entity 'Name'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names."
Select id,createdby.username,createdby.id,createdby.email,createdby.IsActive,CreatedById,Createdby.Type__c from sampleobject__c
Is this possible to reference custom field on standard user object using createdby?