<?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> |