I’m experimenting with the plugin (now core) External Storage. The files do not appear to be stored in a format, which would be usable (read only) via something like FTP.
Does anyone have a suggestion on how I could store attachments in a folder structure matching ticket numbers?
EDIT: Even extracting the files (And keep the data in the RT database) would be good.
One why is to create a page which query the Attachment table and join all tickets which refer/use this attachment. but that is a external script/page from RT it self and not smothering you can do with RT it self.