Page 1 of 1

SP Image/Attachments

Posted: Tue Jun 07, 2016 2:36 pm
by cgriffin
For pre 3.0 files, I am able to return data for attachments with the following:

SELECT O.Number, DI.Description, DI.FileType
FROM core.Blob cb
RIGHT JOIN pf.[Order] O ON o.Guid = cb.ID
JOIN dbo.DocumentImage DI ON DI.OrderID = O.Guid
WHERE O.Number = "I would place a pre 3.0 file number here."

However, for files created post 3.0, this same query does not return results.

Can you provide the post 3.0 query, please?

Re: SP Image/Attachments

Posted: Thu Jun 09, 2016 5:59 pm
by BobRichards
Attachments are retrieved using the Select API. They are not available in SQL.

Re: SP Image/Attachments

Posted: Mon Jun 13, 2016 3:16 pm
by cgriffin
Good afternoon Bob,

Just to clarify, we are not looking for the attachments themselves, just the Name, Description, Type, Source, Size, Last Modified on, Last Modified by, or at the very least just the description of the attachment. Therefore, we are only looking to retrieve the metadata. Please see screenshot attached.

Thank you,
Colin.

Re: SP Image/Attachments

Posted: Mon Jun 13, 2016 5:21 pm
by BobRichards
This information is not available from the SQL tables. You must open the order and query the associated API for a list of attachments.