[GRASS-dev] Re: [GRASS GIS] #561: meta: add a new "normal" bug priority

[GRASS GIS]

#561: meta: add a new "normal" bug priority
--------------------------+-------------------------------------------------
  Reporter:  hamish       |       Owner:  grass-dev at lists.osgeo.org
      Type:  enhancement  |      Status:  closed                   
  Priority:  minor        |   Milestone:  Website                  
 Component:  Website      |     Version:                           
Resolution:  fixed        |    Keywords:  trac                     
  Platform:  Unspecified  |         Cpu:  Unspecified              
--------------------------+-------------------------------------------------
Comment (by neteler):

 re "all tickets modified in the last week":

 The "Active ticket" code is
 {{{
 SELECT p.value AS __color__,
    id AS ticket, summary, component, version, milestone, t.type AS type,
    (CASE status WHEN 'assigned' THEN owner||' *' ELSE owner END) AS owner,
    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 IN ('new', 'assigned', 'reopened')
   ORDER BY p.value, milestone, t.type, time
 }}}

 For trac admins, there is "Copy report" to clone this - then a
 modification could be implemented, please suggest.

 re "open tickets reported by me" - likewise.

-- 
Ticket URL: <https://trac.osgeo.org/grass/ticket/561#comment:3>
GRASS GIS <http://grass.osgeo.org>