DMW Delete document from SENT folder
Logged on SQL and ran the below. ????=Document id. This line must be a valid user " ,'service'" For some AU sites use 1000 Begin tran DECLARE @DOCID bigint Set @DOCID = ???? Update [Document] set isdeleted = 1 where DocumentID = @DOCID INSERT INTO [dbo].[Deletion] ([DocumentId] ,[ActionedByUser] ,[ActionedByServiceCode] ,[Reason] ,[DateTimeDeletion]) VALUES (@DOCID ,'service' ,'WinscribeText' ,'Manually deleted in database as per user request – document not opening' ,GETDATE()) Commit tran Specific to APAC Cloud Begin tran DECLARE @DOCID bigint Set @DOCID = ???? Update [Document] set isdeleted = 1 where DocumentID = @DOCID INSERT INTO [dbo].[Deletion] ([DocumentId] ,[ActionedByUser] ,[ActionedByServiceCode] ,[Reason] ,[DateTimeDeletion]) VALUES (@DOCID ,'1000' ,'WinscribeText' ,'Manually deleted in database as per user request – document not opening' ,GETDATE()) Commit tran