Simple display of usernames and contact details of project members
|Reported by:||Owned by:||Jonas Borgström|
When starting to use trac I wanted to get a list of the developer login names and their email addresses, so I could tell whether the reason they were not getting ticket emails was because they hadn't set this up with '/settings', or some other reason.
I ended up writing a custom report, like this (debian, trac 0.10.3-1etch2):
SELECT a.value AS developer, b.value AS email FROM session_attribute a, session_attribute b WHERE a.sid = b.sid and a.name = 'name' and b.name='email' ORDER BY a.value
which is a bit yucky as it exposes details of the session_attribute table. Also it does not list people who have never visited '/settings' yet - it would be nicer to pull the names from the permission table but my sql-foo isn't up to that yet.
I searched for a macro or plugin that would do this, in vain. It would be useful to have this functionality available as a macro.
There are some privacy implications with exposing email addresses like this. Possibly the feature could be built into the admin pages, ie TRAC_ADMIN would be required to view the information.
Not sure what the component should be here, please adjust as you think fit.