revisions-postgresql.xql

DB Query file

Related Files

[ hide source ] | [ make this the default ]

File Contents

<?xml version="1.0"?>

<queryset>
  <rdbms><type>postgresql</type><version>7.1</version></rdbms>

  <fullquery name="revisions_info">
    <rdbms><type>postgresql</type><version>8.4</version></rdbms>
      <querytext>
        select  ci.name, n.revision_id as version_id,
        person__name(n.creation_user) as author,
        n.creation_user as author_id,
        to_char(n.last_modified,'YYYY-MM-DD HH24:MI:SS') as last_modified_ansi,
        n.description,
        acs_permission.permission_p(n.revision_id,:user_id,'admin') as admin_p,
        acs_permission.permission_p(n.revision_id,:user_id,'delete') as delete_p,
        char_length(n.data) as content_size,
        content_revision__get_number(n.revision_id) as version_number
        from cr_revisionsi n, cr_items ci
        where ci.item_id = n.item_id and ci.item_id = :page_id
        and acs_permission.permission_p(n.revision_id, :user_id, 'read')
        order by n.revision_id desc
      </querytext>
  </fullquery>

</queryset>