What should I spect when the account is null in the below code?
SELECT Id, name, Account__c
FROM AccountChildren
WHERE Account__r.someField = true
I am having issues debugging the query and I would like to know what it is supposed to happen
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.
Sign up to join this communityWhat should I spect when the account is null in the below code?
SELECT Id, name, Account__c
FROM AccountChildren
WHERE Account__r.someField = true
I am having issues debugging the query and I would like to know what it is supposed to happen
As Pranay mentioned in the comments you will not see an error. You can easily test this by creating an Opportunity and not assigning an Account. Then run the following query in the Developer console:
SELECT Id, name, AccountId
FROM Opportunity
WHERE Account.Name ='test'