I have a lookup field on case which points to case object. (Field: Parent__c). I want to query child case records from a parent case using an aggregate query. Below is the query I have used-
[SELECT Id, (SELECT Id,parent__c FROM Cases) FROM Case WHERE Id IN:SetIds ]
However, this query is not returning anything in 'Cases' in spite of 'Child Relationship Name' for the field being 'Cases'. I know I am definitely missing something here. Hence request someone to please help me towards implementing my requirement.