Createdby cannot reference custom field?

Question

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?

Thany you.

stuckKnowledge · Answer

this is most likely a known issue that should've been solved in SF Summer '15 release (https://help.salesforce.com/articleView?id=000339711&mode=1&sfdcIFrameOrigin=null&type=1)
Try upgrading your apex class version to the laets

Ishwar Mete · Answer

Custom Field on User object can be accessed in SOQL like standard fields.
In your case check make the field is visible to the user.
(Customize > Users > Fields > Type(or whichever custom field is created) 
Click on button > 'Set Field Level Security'
Make it visible to your profile.

That's it.

Createdby cannot reference custom field?

2 Answers

Add your own answers!

Ask a Question