I would like to bulk remove subscriptions to documents based on their parent folder.
I am using this to delete the subscription to an individual document based on the UUID.
I am using this to delete the subscription to an individual document based on the UUID.
Code: Select all
This works well, but I have an entire folder full of documents that needs to have there subscriptions removed. Can I write a script to poll the data base to get the UUIDs of all the files in a specific folder, then create a while loop to insert those UUIDs into the above code to loop through the removal process?DELETE FROM OKM_NODE_SUBSCRIPTOR WHERE NSB_NODE = 'a621eb44-3136-467f-8848-de904147f709';