once you establish how a record gets tagged as "it has no children" you break from the loop. That being said DON'T use recursive selects for an adjacency list....you don't want to loose control over how many queries you launch. If you need, rebuild the structure in python from a single select, or use CTE with raw executesql.
On Sunday, June 12, 2016 at 7:01:05 PM UTC+2, Alex Glaros wrote: > > how to phrase recursive join on an adjacency list? > > say you want to join on a particular node, and include children of > children > > ORG_CHART_TABLE > 1. employee_id > 2. supervisor_id (references the parent "employee_id" in same table) > > Pseudo code: > > for employee_id = "Joe" > find all children with supervisor_id = "Joe" > keep selecting children of children records > > thanks > > Alex Glaros > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
