Edgewall Software

Changes between Initial Version and Version 1 of Ticket #6160


Ignore:
Timestamp:
Oct 10, 2007, 9:58:15 AM (17 years ago)
Author:
Christian Boos
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #6160 – Description

    initial v1  
    11The below query orders all milestones and tickets by their respective due date or the time of creation in case of the ticket, as was implemented before.
    22
    3 It would be nice to have a DUE datatype being mapped to the datetime datatype in order for displaying the due date in the __group__ header along with the t.milestone name.
     3It would be nice to have a DUE datatype being mapped to the datetime datatype in order for displaying the due date in the `__group__` header along with the `t.milestone` name.
    44
    55TIA
    … …  
    99
    1010-----------------
    11 
     11{{{
    1212SELECT p.value AS __color__,
    1313   t.milestone ||' Release' AS __group__,
    … …  
    2222  WHERE status IN ('new', 'assigned', 'reopened')
    2323  ORDER BY (milestone IS NULL),m.due, p.value, t.type, time
    24 
    25 
     24}}}