Reports can't be used with some realms
|Reported by:||anonymous||Owned by:|
Description (last modified by )
We can create for non-ticket realms like this:
SELECT name as id, 'milestone' as _realm FROM milestone
But this doesn't work for all realms:
SELECT value as id, 'repository' as _realm FROM repository WHERE name='name'
This SQL report above does not list any repositories, even though the following does list them:
SELECT value as id, 'repository' as _ignore FROM repository WHERE name='name'
(But here the rows link to the ticket realm.)
The reason is a hardcoded check in Trac that's wrong for some realms. It guesses that when realm is
repository, the appropriate permission is probably
REPOSITORY_VIEW. But no such permission exists, so all rows are hidden.
(This problem was also reported to a plugin where this check also fails.)