function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
aalazzaniaalazzani 

How can I determine if any elements were retrieved by the query?

I am writing a query in an Apex Code method and I want to make sure that there is at least one element retrieved before I start accessing elements by index. I tried .length, .count, .length() but none gave me how many elements were retrieved by the query. How can I determine if any elements were retrieved by the query? Here is my code below and thanks in advance for your help.

Thanks,

Aref

Code:
LeadAssignment__c[] defaultLeadAssignments = [Select User__c from LeadAssignment__c where Name = '00000'];

if(defaultLeadAssignments.length > 0){
 defaultUser  = defaultLeadAssignments[0].User__c ; 
}

Message Edited by aalazzani on 11-16-2007 12:27 AM

Message Edited by aalazzani on 11-16-2007 12:29 AM

Message Edited by aalazzani on 11-16-2007 12:30 AM

tschatztschatz

I think lists work with myList.size()

tryCode:

if(defaultLeadAssignments.size() > 0){
 defaultUser  = defaultLeadAssignments[0].User__c ; 
}

//or 

if(0 < defaultLeadAssignments.size()){
 defaultUser  = defaultLeadAssignments[0].User__c ; 
}


 
aalazzaniaalazzani
Hi tschatz,

Yes that worked. Thanks a lot.

Aref