Changes between Version 48 and Version 49 of TimeTracking

Timestamp:

Aug 25, 2006, 4:44:32 PM (18 years ago)

Author:

Ben Williams <bwilliams@…>

Comment:

Added query for MYSQL

TimeTracking

@@ -123 +123 @@
 }}}
 
+===== MYSQL =====
+
+{{{
+#!sql
+SELECT DISTINCT 
+   id AS ticket,
+   (CASE WHEN pl.value IS NULL THEN '' ELSE pl.value END) AS planned,
+   (CASE WHEN s.value IS NULL THEN '' ELSE s.value END) AS spent,
+   (CASE WHEN r.value IS NULL THEN '' ELSE r.value END) AS remaining,
+   (CASE WHEN ((s.value + r.value) - pl.value) IS NULL THEN ''
+         WHEN((s.value + r.value) - pl.value) = "0.0" THEN ' ' ELSE (s.value + r.value) - pl.value END) as accuracy,
+   milestone AS customer,
+   summary, component, status 
+  FROM ticket t
+  LEFT OUTER JOIN ticket_custom pl ON
+       (t.id=pl.ticket AND pl.name='tt_estimated')
+  LEFT OUTER JOIN ticket_custom s ON
+       (t.id=s.ticket AND s.name='tt_spent')
+  LEFT OUTER JOIN ticket_custom r ON
+       (t.id=r.ticket AND r.name='tt_remaining')
+  ORDER BY milestone
+}}}
+
 ==== Using a Subversion commit hook (optional) ====