index.xql

DB Query file

Related Files

• packages/attachments/www/download/index.xql

[ hide source ] | [ make this the default ]

File Contents

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

  <fullquery name="select_version_id">
    <querytext>
      select live_revision
      from cr_items, attachments
      where cr_items.item_id = attachments.item_id
      and attachments.object_id = :object_id
      and attachments.item_id = :attachment_id
    </querytext>
  </fullquery>

  <fullquery name="select_version_id_revision">
    <querytext>
      select live_revision
        from cr_items ci,
             attachments at
       where ci.live_revision = at.item_id
         and at.item_id = :attachment_id
         and at.object_id = :object_id;
    </querytext>
  </fullquery>

</queryset>