forums-portlet-postgresql.xql

DB Query file

Related Files

• packages/forums/lib/forums-portlet.tcl
• packages/forums/lib/forums-portlet.adp
• packages/forums/lib/forums-portlet-postgresql.xql
• packages/forums/lib/forums-portlet-oracle.xql

[ hide source ] | [ make this the default ]

File Contents

<queryset>
<rdbms><type>postgresql</type><version>7.3</version></rdbms>

<fullquery name="hot_topics"><querytext>
SELECT
  b.subject AS subject,
  b.message_id AS thread_id,
  a.message_id AS message_id
FROM
  (SELECT message_id, tree_sortkey, posting_date
   FROM forums_messages
   WHERE forum_id IN
    (SELECT forum_id FROM forums_forums WHERE package_id = :package_id
    and enabled_p = 't')
   ORDER BY posting_date DESC LIMIT $n) a,
  forums_messages b
WHERE
  b.parent_id IS NULL
  AND b.tree_sortkey = tree_root_key(a.tree_sortkey)
  AND b.forum_id IN
   (SELECT forum_id FROM forums_forums WHERE package_id = :package_id
   and enabled_p = 't');
</querytext></fullquery>

<fullquery name="new_topics"><querytext>
SELECT
  subject, message_id
FROM
  forums_messages_approved
WHERE
  forum_id IN
   (SELECT forum_id FROM forums_forums WHERE package_id = :package_id
   and enabled_p = 't')
  AND parent_id IS NULL
ORDER BY
  posting_date DESC
LIMIT $n
</querytext></fullquery>
</queryset>