<?xml version="1.0"?>

<queryset>
   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>

<fullquery name="tasks_select">
<querytext>

    select tt.creation_user as user_id,
           acs_object.name(tt.creation_user) as user_name,
           count(ticket_id) as total,
           sum(decode(lower(wfc.state),'active',1,0)) as active,
           sum(decode(lower(wfc.state),'suspended',1,0)) as suspended,
           sum(decode(lower(wfc.state),'canceled',1,0)) as canceled,
           sum(decode(lower(wfc.state),'finished',1,0)) as finished,
           max(tt.creation_date) as latest,
           min(tt.creation_date) as earliest
      from ttracker_tickets tt, 
           ttracker_categories tc, 
           wf_cases wfc
     where tc.package_id = :package_id and
           tt.category_id = tc.category_id and
           tt.ticket_id = wfc.object_id 
           [ad_dimensional_sql $dimensional] 
     group by tt.creation_user
     [ad_order_by_from_sort_spec $orderby $table_def]     
      
</querytext>
</fullquery>



<partialquery name="posted_last_year">
<querytext>

tt.creation_date + 365 > sysdate

</querytext>
</partialquery>



<partialquery name="posted_last_3mos">
<querytext>

tt.creation_date + 90 > sysdate

</querytext>
</partialquery>



<partialquery name="posted_last_month">
<querytext>

tt.creation_date + 30 > sysdate

</querytext>
</partialquery>


 
</queryset>