Select the search type
  • Site
  • Web
Search
You are here:  Support/Forums
Support

Bring2mind Forums

How to delete all Entries from one Portal
Last Post 05/29/2009 3:21 PM by Ulrich Jenzer. 2 Replies.
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Ulrich Jenzer
New Member
New Member
Posts:22


--
05/25/2009 9:22 AM

Good morning Peter

I have created a portal template with all content and then created a new portal. Now I have of course also the entire contents of DMX in the new portal.
How can I delete all DMX Entries for the new portal, without the document producers receive a notification?
DELETE .... FROM .... WHERE PortalID=2 .... ?

Best Regards

Ueli

Peter Donker
Veteran Member
Veteran Member
Posts:4536


--
05/27/2009 4:28 PM
Hi Ueli,

You could try to do this at the data level.

DELETE FROM DMX_Entries WHERE PortalId=x

Note you might have to cleanup the DMX_ShortTexts and Longtexts tables:

DELETE FROM DMX_ShortTexts
WHERE TypeKey='ENT' AND
NOT EXISTS (SELECT e.EntryId FROM DMX_Entries e WHERE e.EntryId=ObjectId)

and then the same for LongTexts.

O, backup your db just in case. I'm pretty sure this will do the trick but you know Murphy's law.

Peter
Ulrich Jenzer
New Member
New Member
Posts:22


--
05/29/2009 3:21 PM
Thanks Peter, it worked.

Yours sincerely Ueli
You are not authorized to post a reply.