Changes between Version 13 and Version 14 of TracIniReportCustomFieldSample

Timestamp:

Mar 11, 2012, 7:11:46 AM (12 years ago)

Author:

signup@…

Comment:

Missed one comparison which should have been 0000-00-00 instead of IS NOT NULL

TracIniReportCustomFieldSample

@@ -175 +175 @@
      WHEN IF (STR_TO_DATE(d.value,'%m/%d/%Y') <> '0000-00-00', 
               STR_TO_DATE(d.value,'%m/%d/%Y'),STR_TO_DATE(d.value,'%Y/%m/%d')) > CURDATE()
-        THEN 'Future Tickets' 
+          THEN 'Future Tickets' 
      WHEN IF (STR_TO_DATE(d.value,'%m/%d/%Y') <> '0000-00-00', 
               STR_TO_DATE(d.value,'%m/%d/%Y'),STR_TO_DATE(d.value,'%Y/%m/%d')) = CURDATE() 
-        THEN 'Today Tickets' 
-     ELSE 'Over Due Tickets' 
+          THEN 'Today Tickets' 
+          ELSE 'Over Due Tickets' 
     END) AS __group__,
-   id AS ticket, IF (STR_TO_DATE(d.value,'%m/%d/%Y') is not null, 
+   id AS ticket, IF (STR_TO_DATE(d.value,'%m/%d/%Y') <> '0000-00-00', 
    STR_TO_DATE(d.value,'%m/%d/%Y'),STR_TO_DATE(d.value,'%Y/%m/%d')) AS 'Due Date', 
    summary, component, version, milestone, t.type AS type, owner, status,