SP Image/Attachments
Posted: Tue Jun 07, 2016 2:36 pm
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?
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?