Blog

Main » 2025 » July » 22

SELECT Case__c, System_Type__c, COUNT(Id) 
FROM Message__c
WHERE System_Type__c = 'reminder'
GROUP BY Case__c, System_Type__c
HAVING COUNT(Id) > 4