Governor Limits on Triggers

[wilbur07]

This line gives me an error in my trigger:

for (Case a: [select Id,CreatedDate,Total_Minutes_Active_Clock__c from Case]) {

because i have more than 1000 cases and the limit on query rows is 1000 in a trigger.

What is the standard method of getting around this limit for apex triggers?

James

[DevAngel]

Hi James,

So you want to evaluation all cases in a trigger? I think you need to think about the problem a little more, unless you plan to modify all of the cases, in which case you may be out of luck. Usually someone will want to find all object that have something in common with the object(s) that caused the trigger to fire. In that case, you will want to limit the objects returned based on that commonality.

What exactly are you trying to accomplish with your trigger?



Cheers