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

DMW - Delete document

DMW Mark document as Deleted

Run SQL query below. ????=Document id.

 
This line must be a valid user "         ,'service'"  For some AU sites use 1000
 
Can check ServiceCode like this:
 
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