project-edit.xql

DB Query file

Related Files

[ hide source ] | [ make this the default ]

File Contents

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

<fullquery name="project_info_update">      
      <querytext>
      
            update bt_projects
            set    description = :description,
                   email_subject_name = :email_subject_name,
                   maintainer = :maintainer
            where  project_id = :package_id
        
      </querytext>
</fullquery>

<fullquery name="project_select">
  <querytext>
        select pa.instance_name as name,
               pr.description, 
               pr.email_subject_name,
               pr.maintainer
        from   bt_projects pr,
               apm_packages pa
        where  pr.project_id = :package_id
        and    pa.package_id = pr.project_id
  </querytext>
</fullquery>

<fullquery name="project_search">
  <querytext>
        select distinct u.first_names || ' ' || u.last_name || ' (' || u.email || ')' as name, u.user_id
        from   cc_users u
        where  upper(coalesce(u.first_names || ' ', '')  ||
               coalesce(u.last_name || ' ', '') ||
               u.email || ' ' ||
               coalesce(u.screen_name, '')) like upper('%'||:value||'%')
        order  by name
  </querytext>
</fullquery>
 
</queryset>