How to move every Orphaned Document to a folder - Support

How to move every Orphaned Document to a folder

From Support

Jump to: navigation, search
INSERT INTO dmfiler (documentkey,folderkey,Timestamp)
SELECT documentkey,'DESTINATION_FOLDER_ID',Null 
FROM [webdocs].[dbo].[dmDocument]
WHERE     (DocumentKey NOT IN
                          (SELECT     documentkey
                           FROM          dmFiler))
Personal tools