grim at reaperworld.com
Tue Jun 3 08:23:59 EDT 2008
Daniel Atallah wrote:
> 2008/6/2 Richard Laager <rlaager at wiktel.com>:
>> Is there a way to find all the tickets with attachments? I'd like to
>> make a pass to find patches on tickets that are not flagged as patches.
> The easiest way I can see to do this is with a query against the
> postgres DB running trac:
> SELECT t.id, a.filename, a.size
> FROM trac_pidgin.ticket t, trac_pidgin.attachment a
> WHERE t.type <> 'patch'
> AND a.type = 'ticket'
> AND a.id = t.id
> AND t.status <> 'closed'
> ORDER BY id;
I thought you could inject sql into custom ticket reports, I could be
wrong, but I thought there was some interface in trac for that...
More information about the Devel