go-to-attachment.xql

DB Query file

Related Files

• packages/attachments/www/go-to-attachment.xql
• packages/attachments/www/go-to-attachment.tcl

[ hide source ] | [ make this the default ]

File Contents

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

  <fullquery name="select_url">
    <querytext>
      select url
        from cr_extlinks
       where extlink_id = :attachment_id
    </querytext>
  </fullquery>

  <fullquery name="select_attachment_info">
    <querytext>
      select r.title,
             i.name,
             o.package_id,
             m.file_extension
        from cr_revisions r,
             cr_items i,
             acs_objects o,
             cr_mime_types m
       where i.item_id = :attachment_id
         and r.revision_id  = i.live_revision
         and i.item_id = o.object_id
         and m.mime_type = r.mime_type
    </querytext>
  </fullquery>

  <fullquery name="select_attachment_info_specific_revision">
    <querytext>
      select r.title,
             o.package_id,
             m.file_extension
        from cr_revisions r,
             acs_objects o,
             cr_mime_types m
       where revision_id = :attachment_id
         and r.revision_id  = o.object_id
         and m.mime_type= r.mime_type
    </querytext>
  </fullquery>

</queryset>