common.apex.runtime.impl.ExecutionException about query.apex HOT 7 CLOSED

Hi, I think you could select Owner.Name instead of Owner.FirstName. Because OwnerId is a polymorphic lookup, which can be a user Id or a group Id. So I guess you cannot select FirstName in this case.

from query.apex.

Actually when I write like this , I am not getting any Issues.

List oCase=[select Id,CaseNumber,ReceivedDate__c,CreatedDate,Owner.FirstName,Owner.Lastname,Origin from Case];

So do we have to follow the Owner.Name only as per your suggestion?

from query.apex.

I see the issue you're facing. I just did an update to fix this issue. You may pull the latest code and try again.

from query.apex.

from query.apex.

Hi @aranwe
In the very early implementation, we enforced field-level security, by traversing all the fields selected, including the fields from the parent object. In order to traverse the fields in the parent object, we had to get the object type of the parent object. If the parent field is a polymorphic lookup, I just randomly chose one, assuming that we could only select the common fields of the polymorphic object types. But when this issue was raised, I realized that assumption wasn't always true (FirstName is not a common field but it can be selected in native SOQL).

Since APEX version 48, we can use the WITH SECURITY_ENFORCED to enforce security checks, instead of traversing all the fields. Therefore I just replaced all the security checking codes with the new WITH SECURITY_ENFORCED keyword. You may find it in this commit f5b2b7c.

from query.apex.

from query.apex.

@HenryRLee
Things are looking good now.
Thanks for your support.

from query.apex.