Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
Given a node with ID "X", how can we delete the values/content of a property with alias "Y" of all the children (and their children) pages of node "X", via an SQL Server query?
So that only the content of the properties will be empty, not deleting the property itself, just their values.
The property we need to empty is a nested content type, all its items need to be removed.
You can use something like this:
set varcharValue = null, textValue = null
from umbracoPropertyData upd
join umbracoContentVersion cv on cv.id = upd.versionId
join umbracoNode un on un.id = cv.nodeId
join cmsPropertyType pt on pt.id = upd.propertyTypeId
where un.nodeObjectType like 'C66BA18E-EAF3-4CFF-8A22-41B16D66A972' and Alias like 'title' and (cv.nodeId = 1053 or un.[path] like '%1053,%')
Just replace the 'title' with Y, and replace the 1053 with the X
is working on a reply...
Write your reply to:
Image will be uploaded when post is submitted