I have a custom entity which has a custom relationship 'User' back to the User table.
I can do
SELECT Id, User__r.Id from MyCustomEntity
However, I want to get a information about the user's manager.
SELECT Id, User__R.Manager__R.email from MyCustomEntity
But I get:
Save error: Didn't understand relationship 'Manager__R' in field path
Is it possible to achieve want I want in SOQL or must I do this in memory programmatically via a separate statement?