Trac Attachments

Gary Kramlich grim at
Tue Jun 3 08:23:59 EDT 2008

Daniel Atallah wrote:
> 2008/6/2 Richard Laager <rlaager at>:
>> 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, a.filename, a.size
> FROM trac_pidgin.ticket t, trac_pidgin.attachment a
> WHERE t.type <> 'patch'
> AND a.type = 'ticket'
> AND =
> AND t.status <> 'closed'
> ORDER BY id;
> -D
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...

Gary Kramlich

More information about the Devel mailing list