Opened 17 years ago
Last modified 9 years ago
#6160 new enhancement
Enhanced Query for All Tickets by Milestone + RFE for a new automatically detected datatype — at Initial Version
| Reported by: | Carsten Klein | Owned by: | Jonas Borgström |
|---|---|---|---|
| Priority: | normal | Milestone: | next-major-releases |
| Component: | report system | Version: | 0.10.3 |
| Severity: | normal | Keywords: | |
| Cc: | Branch: | ||
| Release Notes: | |||
| API Changes: | |||
| Internal Changes: | |||
Description
The 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.
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.
TIA
Carsten
SELECT p.value AS color,
t.milestone ' Release' AS group, t.id AS ticket, t.summary, t.component, t.version, t.type AS type,
(CASE status WHEN 'assigned' THEN t.owner ' *' ELSE t.owner END) AS owner, t.time AS created, m.due as date, t.changetime AS _changetime, t.description AS _description, t.reporter AS _reporter
FROM ticket t LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority' LEFT JOIN milestone m ON m.name = milestone WHERE status IN ('new', 'assigned', 'reopened') ORDER BY (milestone IS NULL),m.due, p.value, t.type, time
