Descendant Pages

About

Descendant pages are pages that have the same or a higher level than the current page in the page system.

The descendant's pages can be queried to create an illustrative list in index pages.

Query

You can query them by using the descendants table of the page sql.

Example:

• All descendants index page (is_index = 1)
• in the next level (depth = 1) than the root home page for the documentation
• ordered by page name ascendant

select from descendants where is_index = 1  and depth = 1 order by name asc 

If you take this query and use it:

• in a iterator

<iterator>
    <data path=":docs:docs">select from descendants where is_index = 1  and depth = 1 order by path asc limit 10 </data>
    <fragment>
  * [[$path|$name]] (Level: $level)
    </fragment>
</iterator>

you would get the second level index page (we have limited to 10 with the limit 10 clause).