Our agency has a large number of tickets in our RT app, and our developers are looking to archive the older tickets in a separate Oracle DB instance and just using a separate interface tool (QLIK I believe?) to reference these older tickets.
Does RT support have and tools we could possibly use to convert the Attachment table’s Content Column from a CLOB to a BLOB datatype? As my developer stated,
The CONTENT column in RT3EMTS.ATTACHMENTS table is a CLOB datatype. It stores the file contents.
When I convert a file that’s a CONTENTTYPE= ‘application/msexcel’ to a BLOB, it won’t convert into an editable file.
Thanks for any recommendations you could provide.