users.xql

DB Query file

Related Files

• packages/wp-slim/www/users.xql
• packages/wp-slim/www/users.tcl
• packages/wp-slim/www/users.adp

[ hide source ] | [ make this the default ]

File Contents

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

<fullquery name="get_wp_users">      
      <querytext>
      
    select p.person_id, p.first_names, p.last_name, count(i.item_id) as num_presentations
    from persons p, cr_items i, acs_objects o, parties
    where i.content_type = 'cr_wp_presentation'
    and   o.object_id = i.item_id
    and   p.person_id = o.creation_user
    and   parties.party_id = p.person_id
    and   o.context_id = :package_id
    group by p.person_id, p.first_names, p.last_name, parties.email

      </querytext>
</fullquery>

 
</queryset>