Blob files correlation in DB

Mihaela V

Vote:

Hi,

I'm having an issue trying to correlate the blob GUID of a newly uploaded image in media panel with the url of the uploaded image. I didn't find anything so far. Do you think you can help me? Is there some table in the DB maybe where I can find the connection between the two? I mean, I'm uploading an image under media panel and I get a new folder under App_Data/blobs. What's the connection between that GUID (of the folder or of the file) and the url/filename from EPI?

Please advise. Thanks in advance.

#148591

May 18, 2016 8:15

valdis

Vote:

Question what comes in my mind - is what do you want to do with that information? Do you want to use it somehow in the site?

This should give you full overview of images saved in blob:

SELECT *  FROM [dbo].[tblContent] c inner join tblContentProperty p on c.pkID = p.fkContentID inner join [dbo].[tblContentLanguage] cl on c.pkID = cl.fkContentID
  where c.fkContentTypeID in (select pkid from [dbo].[tblContentType] where name = 'NAME OF YOUR CONTENT TYPE FOR IMAGE')

#148712

May 20, 2016 17:33

Johan Björnfot

Vote:

A media item has a reference to its blob in column BlobUri in tblContentLanguage. The reference is in format of an Uri where the segments of the URI describes how to locate the blob.

#149382

May 31, 2016 9:27