Query+-+All+Names+in+Tree

=Trees=

Two related problems 1) Finding all names in a selected person's tree 2) Count Trees

1) Finding all names in selected person's tree Does anyone have any idea how to emulate the function that is in the RM Mark Group of "Everyone in the highlighted person's tree"? RM does this very efficiently/quickly.I break the relationship between parents and then use it to create groups of maternal and paternal lines. It works ok, but would be a lot more efficient if I could automate it using SQL.

This produces a subset of the full tree; not the solution... (Tom, May 8)

2) Count Trees I sometimes forget about this function, but it is very useful in finding orphans

Hopefully I did this right. Thanks in advance marc

include component="comments" page="page:Query - All Names in Tree" limit="10"