Trac Attachments

[Gary Kramlich]

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;
>
> -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