You need to sign in to do that
Don't have an account?
Support 3743
Lookup relationship returning null
Hi, I created a custom lookup relationship so that I can access Opportunity when I'm querying Contact:
What I want is something like this:
SELECT Email, Look_Opportunity__r.Stage FROM Contact WHERE Oppportunity.Stage != "Not Ready" AND Email != null
However, when I call this the query it returns null for Look_Opportunity:
What's wrong with my code? Many thanks for the help!
What I want is something like this:
SELECT Email, Look_Opportunity__r.Stage FROM Contact WHERE Oppportunity.Stage != "Not Ready" AND Email != null
However, when I call this the query it returns null for Look_Opportunity:
What's wrong with my code? Many thanks for the help!
Oppportunity.Stage != "Not Ready" AND Email != null and run SOQL again