About • Download • Documentation • Wiki • Forums • Contribute • Support The Toolkit for Online Communities 15889 Community Members, 0 members online, 1757 visitors today Log In Register

index-oracle.xql

index-oracle.xql

DB Query file

Related Files

• /usr/local/openacs.org/packages/general-comments/www/index.xql
• /usr/local/openacs.org/packages/general-comments/www/index.tcl
• /usr/local/openacs.org/packages/general-comments/www/index.adp
• /usr/local/openacs.org/packages/general-comments/www/index-postgresql.xql
• /usr/local/openacs.org/packages/general-comments/www/index-oracle.xql

[ hide source ] | [ make this the default ]

Content File Source

<?xml version="1.0"?>

<queryset>
   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>

<fullquery name="comments_select">      
      <querytext>

    select g.comment_id,
           r.title, 
           acs_object.name(o.creation_user) as author,
           o.creation_user, 
           decode(i.live_revision,null,0,1) as live_version_p,
           decode(i.live_revision,r.revision_id,1,0) as approved_p, 
           o.creation_date
      from general_comments g,
           cr_items i,
           cr_revisions r,
           acs_objects o
     where g.comment_id = i.item_id and
           r.revision_id = o.object_id and
           r.revision_id = content_item.get_latest_revision(g.comment_id) and
           o.creation_user = :user_id
          [ad_dimensional_sql $dimensional]
    [ad_order_by_from_sort_spec $orderby $table_def]
     
      </querytext>
</fullquery>

<partialquery name="modified_last_24hours">      
      <querytext>

		creation_date + 1 > sysdate

      </querytext>
</partialquery>

<partialquery name="modified_last_week">      
      <querytext>

		creation_date + 7 > sysdate

      </querytext>
</partialquery>

<partialquery name="modified_last_month">      
      <querytext>

		creation_date + 30 > sysdate

      </querytext>
</partialquery>
 


 
</queryset>