I'm using the workbenc to select records having more than one certain related record.
SELECT Count(Id),Person__c FROM Work_Relationship__c group by Person__c having count(Id) > 1.
But I have the folloving error:
EXCEEDED_ID_LIMIT: Aggregate query does not support queryMore(), use LIMIT to restrict the results to a single batch
If I limit the result to 200 I don't get of course the error.
Is there anyway/work around to solve this ?