I have a question around the SOQL query below.
SELECT Assignee.Name, Assignee.Profile.Name, Assignee.UserRole.Name, Assignee.Profile.UserLicense.Name FROM PermissionSetAssignment WHERE PermissionSet.Name = 'Lightning_Experience_User'
Why is it that I have to use assignee.blah and why can't I use user.blah in the query?
My query returns the result below, notice the tab shows User.Name, User.UserRole.
Whereas I can use the object API names for other objects such as Profile and UserLicense.
I hope that makes sense what I am trying to explain.
Thank you
PermissionSetAssignment
object does not have any field by the nameUser
. The field reference to User object is named asAssignee
.