AI OnAI Off
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')
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.
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.