[Trac-tickets] Re: [The Trac Project] #222: 'Assign to' as popup list

[The Trac Project]

#222: 'Assign to' as popup list
-----------------------------------+----------------------------------------
 Reporter:  anonymous              |        Owner:  cmlenz
     Type:  enhancement            |       Status:  closed
 Priority:  high                   |    Milestone:  0.9   
Component:  ticket system          |      Version:  devel 
 Severity:  normal                 |   Resolution:  fixed 
 Keywords:  users list assignment  |  
-----------------------------------+----------------------------------------
Changes (by dserodio at gmail.com):

  * cc:  manuzhai at gmail.com, gunnar at wageknecht.org => manuzhai at gmail.com,
         gunnar at wageknecht.org, dserodio at gmail.com

Comment:

 Where is the list of users is taken from after all? In [1342], I can see a
 {{{get_known_users}}} method which queries
 {{{
 SELECT DISTINCT s.username, n.var_value, e.var_value
 FROM session AS s
 LEFT JOIN session AS n ON (n.sid IS NULL
  AND n.username=s.username AND n.var_name = 'name')
 LEFT JOIN session AS e ON (e.sid IS NULL
  AND e.username=s.username AND e.var_name = 'email')
 WHERE s.sid IS NULL ORDER BY s.username
 }}}

 But if I run this query on the SQLite prompt, I get:
 {{{
 SQL error: no such column: s.username
 }}}

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