I can query the child cases for current case by something like below,
list<case> parentids=trigger.new select id,status from case where parentid=:parentids
What if the children have more children? Does it make sense to have more than one level hierarchical relationship? Should I use lookup filter on parent case to allow only parent cases linked to child case and not child to child relationship? What's the best practice?
Is that possible to query all cases related to parent case (child, grand child etc)? Can somebody give me an idea to retrieve all related records?