approve-or-reject-2.xql

DB Query file

Related Files

[ hide source ] | [ make this the default ]

File Contents

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

<fullquery name="creation_email_select">      
      <querytext>
      
        select da.archive_name,
               dar.creation_user,
               dar.version_name,
               u.email as creation_email
          from download_arch_revisions_obj dar, download_archives_obj da, cc_users u
         where da.archive_id = dar.archive_id and dar.revision_id = :revision_id
         and u.user_id = dar.creation_user
    
      </querytext>
</fullquery>

 
<fullquery name="approving_user_select">      
      <querytext>
      
        select email as approving_email,
               first_names || ' ' || last_name as approving_name
          from cc_users 
         where user_id = :user_id
    
      </querytext>
</fullquery>

 
</queryset>