Notifications
Clear all
Topic starter
Hello,
I have a document that was opened as an Append, I can't see the append from the Documents view, but I can see it in the Documents for Edit Window and I can see the information through a SQL Query. I am unable to select the Edit button or do anything with this document. I have tried corrupted document and locked fixes from the toolbox.
Does anyone have any ideas or SQL queries to get rid of this document or sign off on it?
Running CPS 12
Thanks in Advance.
Posted : December 29, 2014 8:27 am
I recommend you just Filing it Error, or if you cannot do that via the interface, you can run this script to do it for you:
UPDATE DOCUMENT
SET DOCTYPE = 24, DOCSTATE = 0, STATUS = 'S'
WHERE SDID = INPUT THE SDID HERE
This will mark that document as a Filed In Error Document, this will not show the contributor of who filed it in error, if you need that, I will have to write a more in-depth script.
Posted : December 29, 2014 9:12 am
Topic starter
Acantu,
I ran this script and there is now text in the document that says filed in error, but the document is still showing in the documents for edit window and on the providers desktop.
When I try to remove it, it says document not signed.
Also the document type is now named Error: .......
Any other ideas?
I appreciate the help.
Posted : December 29, 2014 10:42 am
Topic starter
This worked. I had to change the Document status to S after running this script and then it worked
(Probably should have done beforehand).
Thank You Acantu!
Posted : December 29, 2014 11:10 am
No problem, glad it was resolved, I have updated the script for your vote, to show it with an 'S' for status.
Posted : December 29, 2014 11:18 am
