When attachment a file to an issue it would be really great if the comment itself linked to the associated attachment.

It's often been commented on by our staff that when theres 3-4 attachments against an issue, finding which attachment is referenced by a comment usually requires feedback with the person attaching the issue.

i.e. An SQL file is attached with a comment of "Run this SQL script prior to deploying version XXXX of the application". If theres several files attached to the ticket, identifying exactly which attachment is being referenced is impossible.

This would also be usefull in the emailed comment template so that when a user reads the comment email, they have a hyperlink directly to the attachment - currently the emails don't even mention that the comment was the result of an attachment.