Skip to content
English
  • There are no suggestions because the search field is empty.

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