SOQL ignores null checks on required lookup fields: Suppose you have one object and some of the records are there on that object. Now when you create one new Lookup field and make it required that means all the existing records will have a null value for that new required lookup field. SOQL seems to expect that required fields can never be … [Read more...]
What to do when SOQL ignores null checks on required lookup fields
How does Salesforce.com do it?
I have always been impressed with the architecture and design of the Salesforce.com platform ever since I started looking at it. The multitenant solutions they have found to common problems such as: how to handle security at an organization, user, profile and field levels how to manage data between the client and the backend (ORM) how to … [Read more...]