For below query:

System.debug([SELECT  ContactMobile FROM Case]);

I'm getting:

15:13:52:137 USER_DEBUG [1]|DEBUG|(Case:{Id=5003C000001YKoSQAW}, Case:{Id=5003C000001YKoNQAW}, Case:{Id=5003C000001YKoIQAW}, Case:{Id=5003C000001YKoDQAW}, Case:{Id=5003C000001YKo8QAG}, Case:{Id=5003C000001YKo3QAG}, Case:{Id=5003C000001YKnyQAG}, Case:{Id=5003C000001YKntQAG}, Case:{Id=5003C000001YHQLQA4}, Case:{Id=5003C000001YH0RQAW}, ...)

Now how to access that. In soql query editor the same query is giving blank rows.

  • It's a List of records. What exactly are you trying to do? – sfdcfox Aug 1 '18 at 10:12

This works perfectly.

ContactMobile value can be null, so if you execute this SOQL it will return blank rows.

When you execute that SOQL in Developer console in execute Anonymous mode then SOQL engine automatically includes Id in any query result.

Refer my question SOQL results returning RecordTypeId which is not included in query

| improve this answer | |

Not the answer you're looking for? Browse other questions tagged or ask your own question.