You need to sign in to do that
Don't have an account?
surveyforce1.3960136686126697E12
Need to find those cases having 200 child cases.
Can anyone please help me in querying those cases having more than 200 child cases.
Need to find those cases having 200 child cases.
Please help...!!!
Need to find those cases having 200 child cases.
Please help...!!!
here the ParentCaseID is the column which represents the self reference.
Select ParentID, count(ParentID) from case group by ParentID
^
ERROR at Row:1:Column:24
Grouped field should not be aggregated: ParentId
select ParentCaseID from case group by ParentCaseID having count(ParentCaseID) > 200.