Toggle Side Panel
Close search

Activity › Forums › Salesforce® Discussions › How to handle "Too many soql queries:101" problem in Salesforce?

Tagged: , , , , , , , , ,

  • Guha

    Member
    February 10, 2018 at 2:15 AM

    Don't use the query inside any for loops. Instead, query the list of all records and store it in a list or set,  and loop through that list to do the set of logic you wanted to do. No queries inside a for loop is the ground rule for apex programming. Google examples for this approach, there are plenty of examples you can find. Happy coding.

  • Rahul

    Member
    February 10, 2018 at 5:46 AM

    Hi,
    Thanks for reply,  but i am not calling to query in loop .
    Here is my code:

    listCaseTCR = [SELECT id,RV_Consignment_Status__c ,CN_Number__c,Case_Category__c,Issue_Type__c,Sub_Title__c
    FROM Case WHERE Issue_Type__c =:'Tech - CR' AND Sub_Title__c IN:subtitle AND CN_Number__c!='NULL' AND Status!='Closed' AND RV_Is_Parent__c=:FALSE];
    if(!listCaseTCR.isEmpty()){
    //for(Case cr : listCaseTCR)
    total = listCaseTCR.size();
    system.debug('total cases of Tech - CR are :'+total);

    for(i=0;i<total;i++)
    {
    cnumber=listCaseTCR[i].CN_Number__c;
    if(cnumber!=Null && cnumber!='')
    trackconsignment(cnumber);
    }
    }

     

    now problem start from here that when i am calling trackconsignment(cnumber); method then this is using 32 soql queries to closed a case and i have a  lot of cases in list listCaseTCR  so it's firing 101 error.
    how to handle it?

    regards,

    Rahul Kumar

Log In to reply.

Popular Salesforce Blogs

Popular Salesforce Videos