printer-view-procs-oracle.xql

DB Query file

Related Files

• packages/wp-slim/tcl/printer-view-procs.xql
• packages/wp-slim/tcl/printer-view-procs.tcl
• packages/wp-slim/tcl/printer-view-procs-postgresql.xql
• packages/wp-slim/tcl/printer-view-procs-oracle.xql

[ hide source ] | [ make this the default ]

File Contents

<?xml version="1.0"?>
<queryset>
   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>

<fullquery name="get_attach_list.get_attachments">      
  <querytext>
    select live_revision as attach_id, display, name as file_name
    from (select live_revision, name
          from cr_items
          where parent_id = :slide_item_id and
                content_type in ('cr_wp_image_attachment', 'cr_wp_file_attachment')
          ) a,
    cr_wp_image_attachments
    where a.live_revision = attach_id(+)
  </querytext>
</fullquery>
 
</queryset>