HTTP/1.1 -1 Read error in cache disk data: SuccessContent-Type: text/plain; charset="utf-8" Last-Modified: Sat, 22 Jan 2022 00:57:07 GMT Content-length: 1131 Connection: Close Proxy-Connection: Close X-Cache: HIT from web1.osuosl.org Server: ProxyTrack 0.5 (HTTrack 3.49.2) -- ## 6: All Tickets By Milestone (Including closed) ## -- -- -- A more complex example to show how to make advanced reports. SELECT p.value AS __color__, t.milestone AS __group__, (CASE status WHEN 'closed' THEN 'color: #777; background: #ddd; border-color: #ccc;' ELSE (CASE owner WHEN $USER THEN 'font-weight: bold' END) END) AS __style__, id AS ticket, summary, component, status, resolution,version, t.type AS type, priority, owner, changetime AS modified, time AS _time,reporter AS _reporter FROM ticket t LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority' ORDER BY (milestone IS NULL), milestone DESC, (status = 'closed'), -- Within each milestone, closed tickets appear at bottom ( -- Closed tickets sort youngest to oldest -- Open tickets sort most urgent to least urgent CASE status WHEN 'closed' THEN changetime ELSE (-1) * CAST( p.value AS INTEGER ) END ) DESC lient] img{ width:100% !