In the cmsPropertyData table, there will be a row containing the data for the umbracoFile alias for each media item (umbracoFile is the default you probably won't have changed that)
If you run the following SQL
SELECT [id]
,[contentNodeId]
,[versionId]
,[propertytypeid]
,[dataInt]
,[dataDate]
,[dataNvarchar]
,[dataNtext]
FROM [dbo].[cmsPropertyData]
where propertytypeid in (Select id from cmsPropertyType where alias = 'umbracoFile')
You should see all of the saved property values for all of your umbracoFile properties.
If you are using the Image Cropper, the media path will be stored inside a JSON blob within the dataNtext field eg:
Media url's
Does anyone know where the url is stored directly in the DB for media objects ?
I can see the ID e.g 1309 in the propertyData table, but I can't see the full url /media/etc...
Thanks
Hi Pete
In the cmsPropertyData table, there will be a row containing the data for the umbracoFile alias for each media item (umbracoFile is the default you probably won't have changed that)
If you run the following SQL
You should see all of the saved property values for all of your umbracoFile properties.
If you are using the Image Cropper, the media path will be stored inside a JSON blob within the dataNtext field eg:
If you are not using the Image Cropper then the path will be stored in the dataNvarchar field:
/media/2553/yourimage.jpg
regards
Marc
Thanks marc i'll give that a go.
is working on a reply...