Forum management
- Threads started by me
- Threads I participate in

Developer forum

Move 1000 + items at once

Hans Ravnsfjall

Posted on 13/06/2018 17:41:03

we have 1.000+ items currently positioned under Group (page) A, but we want to move all these items under Group B

Is this possible to do somehow at once? Anybody eg have a SQL sentence I could use in Firehose? Would be way to time consuming to move them one by one.

/Hans

Replies

Vladimir Shushunov

Posted on 14/06/2018 08:24:51

This post has been marked as an answer

Hi Hans,

Your items are subpages?
If so then you may use SQL:

Update Page set [PageParentPageId] = newPageId where [PageParentPageId] = oldPageId

Please be careful....

Best regards,
Vladimir

Votes for this answer: 1

Hans Ravnsfjall

Posted on 14/06/2018 08:55:47

Hi Vladimir

Thank you. I tried this

Update Page set [PageParentPageId] = 6255 where [PageParentPageId] = 9766

And SQL FIREHOSE said 1000+ records where affected

However, in the pagetree, they are still placed under 9766

Any idea how this could be? NB: 9766 is a first child of 6255

/Hans

Nicolai Pedersen

Posted on 14/06/2018 09:34:39

This post has been marked as an answer

You need to reset the pagetree cache when you do thinks directly on the database. You can do that by creating a test page and delete it again (delete updates the entire cache).

BR Nicolai

Votes for this answer: 1

Hans Ravnsfjall

Posted on 14/06/2018 09:40:47

Thanx :) Works like a charm :)

/Hans

Jens Mouritzen

Posted on 21/02/2019 14:58:53

We got an issue were we havee deleted all our unpublished paragraphs with these queries in firehose:

DELETE Paragraph WHERE ParagraphShowParagraph = 'false'

and this query as well

DELETE Paragraph WHERE ParagraphShowParagraph = 0

We have done the "Create paragraph to refresh the cache". But the paragraphs persists.

2019-02-21_14_58_28-Dynamicweb_Admin_–_Google_Chrome.png

You must be logged in to post in the forum