http://localhost/ticket/538 <p> Update report queries with more recent versions (below are report queries shipped with trac 0.11.7): </p> <p> NB: Report 1 has already been done. </p> <blockquote> <p> id | query </p> </blockquote> <hr /> <blockquote> <blockquote> <p> 1 | </p> <blockquote> <p> : SELECT p.value AS <span class="underline">color</span>, : id AS ticket, summary, component, version, milestone, t.type AS type, : owner, status, : time AS created, : changetime AS _changetime, description AS _description, : reporter AS _reporter : FROM ticket t : LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority' : WHERE status &lt;&gt; 'closed' : ORDER BY CAST(p.value AS integer), milestone, t.type, time : </p> </blockquote> <p> 2 | </p> <blockquote> <p> : SELECT p.value AS <span class="underline">color</span>, : version AS <span class="underline">group</span>, : id AS ticket, summary, component, version, t.type AS type, : owner, status, : time AS created, : changetime AS _changetime, description AS _description, : reporter AS _reporter : FROM ticket t : LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority' : WHERE status &lt;&gt; 'closed' : ORDER BY (version IS NULL),version, CAST(p.value AS integer), t.type, time : </p> </blockquote> <p> 3 | </p> <blockquote> <p> : SELECT p.value AS <span class="underline">color</span>, </p> <table class="wiki"> <tr>: 'Milestone '<td style="text-align: left">milestone AS <span class="underline">group</span>, </td></tr></table> <p> : id AS ticket, summary, component, version, t.type AS type, : owner, status, : time AS created, : changetime AS _changetime, description AS _description, : reporter AS _reporter : FROM ticket t : LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority' : WHERE status &lt;&gt; 'closed' : ORDER BY (milestone IS NULL),milestone, CAST(p.value AS integer), t.type, time : </p> </blockquote> <p> 4 | </p> <blockquote> <p> : : SELECT p.value AS <span class="underline">color</span>, : owner AS <span class="underline">group</span>, : id AS ticket, summary, component, milestone, t.type AS type, time AS created, : changetime AS _changetime, description AS _description, : reporter AS _reporter : FROM ticket t : LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority' : WHERE status = 'accepted' : ORDER BY owner, CAST(p.value AS integer), t.type, time : </p> </blockquote> <p> 5 | </p> <blockquote> <p> : SELECT p.value AS <span class="underline">color</span>, : owner AS <span class="underline">group</span>, : id AS ticket, summary, component, milestone, t.type AS type, time AS created, : description AS _description_, : changetime AS _changetime, reporter AS _reporter : FROM ticket t : LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority' : WHERE status = 'accepted' : ORDER BY owner, CAST(p.value AS integer), t.type, time : </p> </blockquote> <p> 6 | </p> <blockquote> <p> : SELECT p.value AS <span class="underline">color</span>, : t.milestone AS <span class="underline">group</span>, : (CASE status : WHEN 'closed' THEN 'color: <a class="closed ticket" href="http://localhost/ticket/777" title="task: Put 503-returning middleware into a module (closed: fixed)">#777</a>; background: #ddd; border-color: #ccc;' : ELSE : (CASE owner WHEN $USER THEN 'font-weight: bold' END) : END) AS <span class="underline">style</span>, : 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'), : (CASE status WHEN 'closed' THEN changetime ELSE (-1) * CAST(p.value AS integer) END) DESC : </p> </blockquote> <p> 7 | </p> <blockquote> <p> : SELECT p.value AS <span class="underline">color</span>, : (CASE status WHEN 'accepted' THEN 'Accepted' ELSE 'Owned' END) AS <span class="underline">group</span>, : id AS ticket, summary, component, version, milestone, : t.type AS type, priority, time AS created, : changetime AS _changetime, description AS _description, : reporter AS _reporter : FROM ticket t : LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority' : WHERE t.status &lt;&gt; 'closed' AND owner = $USER : ORDER BY (status = 'accepted') DESC, CAST(p.value AS integer), milestone, t.type, time : </p> </blockquote> <p> 8 | </p> <blockquote> <p> : SELECT p.value AS <span class="underline">color</span>, : (CASE owner : WHEN $USER THEN 'My Tickets' : ELSE 'Active Tickets' : END) AS <span class="underline">group</span>, : id AS ticket, summary, component, version, milestone, t.type AS type, : owner, status, : time AS created, : changetime AS _changetime, description AS _description, : reporter AS _reporter : FROM ticket t : LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority' : WHERE status &lt;&gt; 'closed' : ORDER BY (COALESCE(owner, <em>) = $USER) DESC, CAST(p.value AS integer), milestone, t.type, time </em></p> </blockquote> </blockquote> </blockquote> en-us http://assets.okfn.org/p/ckan/img/ckan_logo_shortname.png http://localhost/ticket/538 Trac 0.12.3 thejimmyg Fri, 07 Jan 2011 15:03:55 GMT http://localhost/ticket/538#comment:1 http://localhost/ticket/538#comment:1 <ul> <li><strong>owner</strong> set to <em>rgrp</em> </li> <li><strong>priority</strong> set to <em>awaiting triage</em> </li> <li><strong>component</strong> set to <em>ckan</em> </li> </ul> <p> Rufus, is this something you want to take on or shall we close the ticket as wontfix? </p> Ticket rgrp Fri, 07 Jan 2011 15:35:37 GMT http://localhost/ticket/538#comment:2 http://localhost/ticket/538#comment:2 <ul> <li><strong>status</strong> changed from <em>new</em> to <em>closed</em> </li> <li><strong>resolution</strong> set to <em>wontfix</em> </li> </ul> <p> We don't use reports any more -- just the query module -- so closing as wontfix. </p> Ticket