Edgewall Software

Changes between Version 13 and Version 14 of TracIniReportCustomFieldSample


Ignore:
Timestamp:
Mar 11, 2012, 7:11:46 AM (10 years ago)
Author:
signup@…
Comment:

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

Legend:

Unmodified
Added
Removed
Modified
  • TracIniReportCustomFieldSample

    v13 v14  
    175175     WHEN IF (STR_TO_DATE(d.value,'%m/%d/%Y') <> '0000-00-00',
    176176              STR_TO_DATE(d.value,'%m/%d/%Y'),STR_TO_DATE(d.value,'%Y/%m/%d')) > CURDATE()
    177         THEN 'Future Tickets'
     177          THEN 'Future Tickets'
    178178     WHEN IF (STR_TO_DATE(d.value,'%m/%d/%Y') <> '0000-00-00',
    179179              STR_TO_DATE(d.value,'%m/%d/%Y'),STR_TO_DATE(d.value,'%Y/%m/%d')) = CURDATE()
    180         THEN 'Today Tickets'
    181      ELSE 'Over Due Tickets'
     180          THEN 'Today Tickets'
     181          ELSE 'Over Due Tickets'
    182182    END) AS __group__,
    183    id AS ticket, IF (STR_TO_DATE(d.value,'%m/%d/%Y') is not null,
     183   id AS ticket, IF (STR_TO_DATE(d.value,'%m/%d/%Y') <> '0000-00-00',
    184184   STR_TO_DATE(d.value,'%m/%d/%Y'),STR_TO_DATE(d.value,'%Y/%m/%d')) AS 'Due Date',
    185185   summary, component, version, milestone, t.type AS type, owner, status,