Today I was working on some reporting requirement and it was like I have Account Info and we have to get all Opportunities related to the child accounts of the given account.
Confused, let me put in more simple here. Here is my account hierarchy.
Child 1 has two Opportunities and Child of Child 2 has two Opportunities. In one go, we have to retrieve all these and show them on UI. I was not aware of how to do this for the first time and after some search found Under Operator that came to rescue me.
Just used Account Under Parent, here is the query and output.
Hope this helps.