Index: openacs-4/contrib/obsolete-packages/ticket-tracker/www/tickets.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker/www/tickets.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/obsolete-packages/ticket-tracker/www/tickets.xql	4 Jun 2001 16:53:27 -0000	1.1
+++ openacs-4/contrib/obsolete-packages/ticket-tracker/www/tickets.xql	12 Jun 2001 06:25:49 -0000	1.2
@@ -1,30 +1,91 @@
 <?xml version="1.0"?>
 <queryset>
 
-<fullquery name="get_priorities">      
-      <querytext>
+<fullquery name="get_priorities">
+<querytext>
       
-    select name,
-           value
-      from ttracker_options
-     where package_id = :package_id
-       and function = 'priority'
+select name,
+       value
+  from ttracker_options
+  where package_id = :package_id and 
+        function = 'priority'
 
-      </querytext>
+</querytext>
 </fullquery>
 
  
-<fullquery name="get_priorities">      
-      <querytext>
+
+<fullquery name="get_severities">
+<querytext>
       
-    select name,
-           value
-      from ttracker_options
-     where package_id = :package_id
-       and function = 'priority'
+select name,
+       value
+  from ttracker_options
+  where package_id = :package_id and 
+        function = 'severity'
 
-      </querytext>
+</querytext>
 </fullquery>
 
+
+
+<partialquery name="creation_user">
+<querytext>
+
+tt.creation_user = $user_id
+
+</querytext>
+</partialquery>
+
+
+
+<partialquery name="status_created">
+<querytext>
+
+wc.state = 'created'
+
+</querytext>
+</partialquery>
+
+
+
+<partialquery name="status_active">
+<querytext>
+
+wc.state = 'active'
+
+</querytext>
+</partialquery>
+
+
+
+<partialquery name="status_suspended">
+<querytext>
+
+wc.state = 'suspended'
+
+</querytext>
+</partialquery>
+
+
+
+<partialquery name="status_canceled">
+<querytext>
+
+wc.state = 'canceled'
+
+</querytext>
+</partialquery>
+
+
+
+<partialquery name="status_finished">
+<querytext>
+
+wc.state = 'finished'
+
+</querytext>
+</partialquery>
+
  
 </queryset>