Is there a SQL script that I can run to unpublish or even delete the descendant's of an entire parent node.
I don't want to do this in the CMS or via code as there are 99k child nodes. I want to do this via SQL as it'll be quicker, any ideas which tables need to be updated if its to be done properly?
Un-publish contents of an entire channel in SQL
Hi Everyone.
Is there a SQL script that I can run to unpublish or even delete the descendant's of an entire parent node.
I don't want to do this in the CMS or via code as there are 99k child nodes. I want to do this via SQL as it'll be quicker, any ideas which tables need to be updated if its to be done properly?
Note - I'm using the latest v8.
Cheers.
James
is working on a reply...