[Trac-tickets] Re: [The Trac Project] #2662: assign tickets to multiple users

[The Trac Project]

#2662: assign tickets to multiple users
-----------------------------+----------------------------------------------
 Reporter:  mala             |        Owner:  jonas
     Type:  enhancement      |       Status:  new  
 Priority:  normal           |    Milestone:  0.12 
Component:  ticket system    |      Version:  0.9.3
 Severity:  normal           |   Resolution:       
 Keywords:  tracobject user  |  
-----------------------------+----------------------------------------------
Comment (by douard at magic.fr):

 I have the same need. Waiting for it to be properly implemented in Trac,
 here is my current hack:

  * add a new ticket report with the following SQL query (this is a very
 naive hack, that do not work if 2 users have similar usernames, eg. 'toto'
 and 'toto_jr' will interfer):
 {{{
 SELECT p.value AS __color__,
    (CASE status WHEN 'assigned' THEN 'Assigned' ELSE 'Owned' END) AS
 __group__,
    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, enum p
   WHERE t.status IN ('new', 'assigned', 'reopened')
 AND p.name = t.priority AND p.type = 'priority' AND owner glob '*$USER*'
   ORDER BY (status = 'assigned') DESC, p.value, milestone, t.type, time
 }}}
  * modified the `Notify.py` (from Trac 0.9.3) source code file, so the
 ticket notify system send a message to every owner of the component (must
 be separated with commas  "," or white spaces):
   File `$PYTHONPATH/site-packages/trac/Notify.py`, line 286, replace:
 {{{
 #!python
                 recipients.append(row[2])
 }}}

   with:
 {{{
 #!python
                 recipients.extend(row[2].replace(',', ' ').split())
 }}}

-- 
Ticket URL: <http://projects.edgewall.com/trac/ticket/2662>
The Trac Project <http://trac.edgewall.com/>