有人能帮我处理下面的顶点代码吗?我想按照调控器的限制更新这段代码吗？

Question

public static void updatecasefields(List<Case> lstcase) {
        //List<Case> lstcase = new list<case>();
        ID devRecordTypeId = Schema.SObjectType.Case.getRecordTypeInfosByDeveloperName().get('CRM_CSR_Case').getRecordTypeId();
        for (Case cs: lstcase)  {
            if(cs.ID != null && cs.RecordTypeId == devRecordTypeId) {
                
                }
                
                List<CRM_CasePick__c> Casp = [SELECT Id, CRM_Carrier_Name__c,CRM_LOB__c, CRM_SLA_Turnaround_Time__c,CRM_Category__c, CRM_Issue_Sub_Type__c,CRM_Issue_Type__c,CRM_Turnaround_Time_Days__c FROM CRM_CasePick__c WHERE CRM_Carrier_Name__c = :cs.GiDP_CarrierName__c AND CRM_Category__c = :cs.CRM_Category__c AND CRM_Issue_Type__c = :cs.CRM_Issue_Type__c AND CRM_Issue_Sub_Type__c = :cs.CRM_Issue_Sub_Type__c AND CRM_LOB__c = :cs.CRM_Line_of_Business__c];                            
                for(CRM_CasePick__c CP: Casp) {
                   cs.CRM_Turnaround_Time_Days__c = cp.CRM_Turnaround_Time_Days__c;
                   cs.CRM_SLA_Turnaround_time__c = cp.CRM_SLA_Turnaround_Time__c;   
                
            }
        }
    }

Answer 1

从for循环中删除SOQL查询--最佳做法是永远不要在循环中运行查询。

现在，它正在对初始列表的每个值运行该查询。如果列表超过100条记录，它将超过调控器限制。