[rt-users] finding largest Attachments

Stephen Turner sturner at MIT.EDU
Mon Aug 16 14:29:51 EDT 2004

I think you need to join with the Transactions table:

select length(A.Content), A.id, T.Ticket  from Attachments A, Transactions T
where A.TransactionId = T.id order by 1


At Monday 8/16/2004 01:53 PM, Dave Dennis wrote:
>Thanks, that makes sense, except the output from Attachments.id
>is that same as the number of a ticket that one might search on
>through RT?
>Kind regards,
>+ Dave Dennis
>+ Seattle, WA
>+ dmd at speakeasy.org
>+ http://www.dmdennis.com

More information about the rt-users mailing list