id summary reporter owner description type status priority component severity resolution keywords cc release 13424 Reports can't list mails due to limitation in Trac permission system anonymous lucid "We can create TracReports like this: {{{#!sql SELECT id, subject, fromheader, toheader, date FROM mailarchive }}} But the rows link to tickets. [TracReports#Automaticallyformattedcolumns Trac documentation] suggests using `'mailarchive' as _realm` to fix this: {{{#!sql SELECT id, subject, fromheader, toheader, date, 'mailarchive' as _realm FROM mailarchive }}} But this does not work because there is a [trac:source:trunk/trac/ticket/report.py@16445:592-594#L592 hardcoded check in Trac] that's wrong for this plugin. It guesses that when realm is `mailarchive`, the appropriate permission is probably `MAILARCHIVE_VIEW`. But it is [source:mailarchiveplugin/trunk/mailarchive/web_ui.py@16565:72,77#L41 actually] `MAIL_ARCHIVE_VIEW`." defect new normal MailArchivePlugin normal