how to filter by child records
Needs to create a view for parent records to be filter by child records
This is a difficult concept because a parent has many children that have many different values which can be filtered many different ways for the one parent record.
In this case, the best way to accomplish this is to determine what children you wish to mark and separate from the others for the parent to look at. For example, an if statement in the child table can be used to pull those records out: if(status= complete, 1,0) so that only my completed children are identified. Then the parent can sum this if statement to get a number of completed children. You can then filter the parent based on this new sum being greater than 0. You can now see your parent records where they have completed children.
Please let us know if you have any questions!