You need to sign in to do that
Don't have an account?
sieb4me
how do i bulkify following code
global class myclass implements Support.MilestoneTriggerTimeCalculator {
global Integer calculateMilestoneTriggerTime(String caseId, String milestoneTypeId){
Case c = [SELECT Priority, Priority_On_Complete__c FROM Case WHERE Id=:caseId];
MilestoneType mt = [SELECT Name FROM MilestoneType WHERE Id=:milestoneTypeId];
if (c.Priority_On_Complete__c == null) {
if (c.Priority != null && c.Priority.equals('P1'))
return 60;
else
if (c.Priority != null && c.Priority.equals('P2'))
return 240;
else
if (c.Priority != null && c.Priority.equals('P3'))
return 480;
else return 0;
}
else {
if (c.Priority_On_Complete__c.equals('P1'))
return 60;
else
if (c.Priority_On_Complete__c.equals('P2'))
return 240;
else
if (c.Priority_On_Complete__c.equals('P3'))
return 480;
else return 0;
}
}
}
global Integer calculateMilestoneTriggerTime(String caseId, String milestoneTypeId){
Case c = [SELECT Priority, Priority_On_Complete__c FROM Case WHERE Id=:caseId];
MilestoneType mt = [SELECT Name FROM MilestoneType WHERE Id=:milestoneTypeId];
if (c.Priority_On_Complete__c == null) {
if (c.Priority != null && c.Priority.equals('P1'))
return 60;
else
if (c.Priority != null && c.Priority.equals('P2'))
return 240;
else
if (c.Priority != null && c.Priority.equals('P3'))
return 480;
else return 0;
}
else {
if (c.Priority_On_Complete__c.equals('P1'))
return 60;
else
if (c.Priority_On_Complete__c.equals('P2'))
return 240;
else
if (c.Priority_On_Complete__c.equals('P3'))
return 480;
else return 0;
}
}
}
I don't see any issue in your code which will hit SOQL limit, can you check is there any other trigger that is geting invoked because of any condition met as a result of this trigger.
Thanks,
Pratik