Skip to main content

how to filter by child records


1 comment

  • Tiffanie Staver
    Alex commented  ·  

    Hi Long,

    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!




Please sign in to leave a comment.

Powered by Zendesk