+ Start a Discussion
sabelstromsabelstrom 

Error in SOQL Query in Trigger context -- but only returned 288 rows, not >1000

When attempting a SOQL query with a child relationship in Trigger context, I get error messages saying the number of rows were exceeded (different error msgs depending on if using direct assignment or trying SOQL For Loop).  When investigating in the Debug Console, the total number of rows returned is only 288.  According to the docs, it seems this should work, as it is less than 1000.  I understand that child relationship queries' results rows add to the overall row count, and based on the test data loaded, this 288 seems correct as far as the total expected parent rows + child rows.  Any help would  be greatly appreciated!!