SOQL ignores : WHERE RequiredLookup__c = null - Ideas - Salesforce Trailblazer Community
Trailblazer Community

All Ideas

Idea Details

Post an Idea
460  Points
Idea has been posted. Give it an upvote or downvote.

SOQL ignores : WHERE RequiredLookup__c = null

Data Import & Integration

SOQL ignores null checks on required lookup fields. It seems to expect that required fields can never be null.
In my case it's a new field, so a bunch of records actually have null values. The following line does not return any results:

System.debug([SELECT Id FROM MySObject__c WHERE RequiredLookup__c = null]);

But as soon as I set the field to NOT required I get my results.

I would suggest to make this more reliable for developers, so they get the results they queried for!

Merge Idea · Flag

  • Upvotes
  • Downvotes



from AppExchange


No results found.

Help us to keep IdeaExchange clean by pointing out overlapping ideas. We'll investigate your suggestion and merge the ideas if it makes sense.



Thanks for your merge suggestion. We will review it shortly and merge the ideas if applicable.

Salesforce takes abuse situations very seriously. Examples of abuse include but are not limited to posting of offensive language or fraudulent statements. To help us process your request as quickly as possible, please fill out the form below describing the situation. For privacy and security reasons, the final outcome of an abuse case may not be revealed to the person who reported it.


Thank you for your feedback. We take abuse seriously and will investigate this issue and take appropriate action.