On Jan 26, 2017, at 7:07 PM, David G. Johnston wrote:
> Thinking aloud - why doesn't just finding every record with 5 descendants not work? Any chain longer than 5 would have at least 5 items.
Oh it works. This is why I ask these questions -- new perspectives!
> Even without recursion you could build out a five-way self-join and any records that make it that far are guilty. I suppose this assumes your setup is non-cyclic.
There could be cyclic records, but that's easy to filter out. A first approach took 40 seconds to run. A little tweaking is necessary, but this is a great start.
THANK YOU! You saved me!