DOCS- Deleting documents from DOCs which are pending approval in Openspace

deleting-documents-from-docs-which-are-pending-approval-in-openspace

DOCS- Deleting documents from DOCs which are pending approval in Openspace

14th March 2023

Deleting documents from DOCs which are pending approval in Openspace

When attempting to delete a document from Docs which has been sent for approval in OpenSpace, this message appears: “The selected document is pending approval. It cannot be deleted.” 

There is not currently a way of deleting documents which are pending approval in OpenSpace from within Iris Docs. The below script will need to be run on the Docs database to remove the publishing state from to document: 

1. Open SQL Server Management Studio on the Docs server 

2. Select the instance where the Docs database is 

3. Expand Databases 

4. Right click the Docs database and select New Query 

5. Copy the below into the new query: 

 
UPDATE NODE 

SET PUBLISHINGSTATE = 55 

WHERE PUBLISHINGSTATE = 52 

and NODENUM in (XXXXX) 

6. Change XXXXX to the reference number of the document in Docs 

Note: you do not need “IRIS” at the start, just enter the number 

7. Click Execute 

This script can be run for multiple documents at once, simply enter each document reference number separated by commas for step 6. 

For example if you were deleting documents with references IRIS1000, IRIS2000 & IRIS3000, the last line of the script would be: and NODENUM in (1000,2000,3000)