I'm working in the Dev Console, trying to help out a friend who needs a custom subset of data that his useless consult can't seem to figure out.
I can successfully query the standard objects, but when I query a custom object, the query comes back empty, no matter how simple it is. It will execute without generating any error messages, but returns zero rows. (And there is definitely data in the object.)
For example, I get nothing from this query on the custom Household obj:
SELECT Id, Name FROM npo02__Household__c (no rows)
But I can successfully retrieve everything expected from a standard object like Contact:
SELECT Id, FirstName FROM Contact (works fine)
I'm coming from a general DB background, but entirely new to Salesforce, so I feel like I must be missing some kind of API setting or something like that. Can someone point me in the right direction here?