forums-chunk.xql

DB Query file

Related Files

• packages/forums/lib/forums/forums-chunk.xql
• packages/forums/lib/forums/forums-chunk.tcl
• packages/forums/lib/forums/forums-chunk.adp

[ hide source ] | [ make this the default ]

File Contents

<?xml version="1.0"?>
<queryset>

    <partialquery name="unread_or_new_query">
        <querytext>
	  approved_thread_count - coalesce(
            (SELECT forums_reading_info_user.threads_read
	       FROM forums_reading_info_user
	      WHERE forums_reading_info_user.forum_id=forums_forums_enabled.forum_id
                AND forums_reading_info_user.user_id=:user_id),
           0) as count_unread
        </querytext>
    </partialquery>

</queryset>