April 2012

Salesforce

How to get a subquery field value using Apex?

List<Account> acct = new List<Account>(); String sql = 'SELECT Name,Phone,External_ID__c,Type,Industry,AccountNumber,Description,FAX,SLA__c,Rating,(SELECT Name,StageName,CloseDate,Probability FROM Opportunities) FROM Account WHERE ID=:localId'; acct = Database.Query(sql);                 for(Account ac:acct)         {             List<Opportunity> opptys = ....