meta: add a new "normal" bug priority

[hamish]

Hi,

could a "normal" priority be created in the trac ticket system and be set as the default?

the default setting of "major" tends to dramatize the priority setting into irrelevance.

thanks, Hamish

[martinl]

Done.

[hamish]

I would like to request a couple more pre-defined bug reports:

+ open tickets reported by me + all tickets modified in the last week

I don't know if the second one is possible, but I thought I'd ask.

Hamish

[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.

[hamish]

Replying to neteler:

re "all tickets modified in the last week":

The "Active ticket" code is

 SELECT p.value AS __color__,
...

... a rather impressive bit of SQL follows ...

re "open tickets reported by me" - likewise.

AFAIK that can be simply built with existing menus into:

​http://trac.osgeo.org/grass/query?status=new&status=assigned&status=reopened&reporter=$OSGEOID

or do those reports require direct SQL into the DB?

thanks, Hamish