Attachments are stored in a proprietary compression format so you cannot retrieve them without using the API to decompress them.
Since you are on SQL you could possibly use the ARS ODBC to pull the attachment (but I have not tried that) Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Sharp Sent: Thursday, August 16, 2012 5:06 PM To: arslist@ARSLIST.ORG Subject: Retrieving Attachments from ARS DBs ? ** Hi All - Our SQL DBA is looking for best practice advice on how to retrieve attachments in INC and CRQ records/work info entries. On page 37 of the DB ref guide, it tells what table(s) to find the attachment images, which we have found. Goal: To retrieve documentation files that are part of work info entries, and are in the ARS attachment data tables. Environment: ARS 7.02 and SQL 2K8 Has anyone done this in the past ? Do you have an example of the SQL statement ? The field element in the B/C tables indicates the attachments are "imaged" types. Thanks in advance very much ! Rick _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
