Example 17-26: Dynamically populating abstract page content

<?xml version="1.0"?>
<!-- Forums.xsql: Home Page Showing all Discussion Forums -->
<page connection="xmlbook" xmlns:xsql="urn:oracle-xsql">
  <xsql:action handler="Paging" rows-per-page="5">
      select count(id) from forum
  </xsql:action>
  <breadcrumbs/>
  <actions>
    <link page="TodaysActiveTopics.xsql" label="Active Topics Today"/>
    <link page="Search.xsql"             label="Search"/>
  </actions>
  <data>
    <xsql:query skip-rows="{@paging-skip}" max-rows="{@paging-max}">
      select f.id as h_id,
             f.name as "Forum",
             to_char(max(t.lastpost),'dd Mon yyyy hh24:mi') as "Last_Post",
             sum(t.postings) as "Posts"
        from forum f,
             forum_topic t
         where t.forumid = f.id
        group by f.id,f.name
        order by name
    </xsql:query>
  </data>
</page>