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
Is it possible to manually update data in the [cmsPropertyData] table?
I have a bunch of records that need updating based on a property data field.
UPDATE cmsPropertyData SET dataNvarchar = '20' WHERE propertytypeid = 23 AND contentNodeId = @umbracoId AND versionId IN (SELECT versionId FROM cmsDocument WHERE published = 1)
Would I need to update another table also? Like [cmsContentXml]?
Safest method would be to go through the service APIs.
Write up an API controller, that runs through the required nodes, and updates them.
The problem is I have 20,000 nodes that need updating. I was hoping for a simple SQL UPDATE solution.
What other database table get updated when you update a property within a node?
I did try to update the cmsPropertyData directly but its not showing up in Umbraco. Has anyone made this work before?
is working on a reply...
Write your reply to:
Image will be uploaded when post is submitted