lineage

Lineage
Lineage was created to allow retrieval of any or all related assets with a single, simple query to the database. This means we can retrieve all ancestors, parents, siblings, children, and descendants as well as know the ranks of all within a group of siblings.
rebuildLineage
make sure you set your environment first:
SQL Cookbook
Select the latest posts from a collaboration system or a group of collaboration systems based on location (a.k.a. - lineage). userDefined1 is implemented as synopsis.
Utility script FAQ
From the WUC session on utility scripts: