Software (include version): Ancora, DocStar IDC, Epicor IDC
Use Case: Client has many batches that need to be deleted
Customer:
Prerequisites: There is a way behind the scenes to delete multiple batches using a simple SQL update statement in the ancoraDocsServerDB. change DB name based on version of IDC
Instructions:
The table you will need to edit is dbo.batch and the column that needs to be updated is State.
You will need to find the batch ID's or a identifier across all batches for this to work using the where clause. The State you will need to apply is '9'. State '9' means deleted.
The update statement will look similar to this. The below will set the two batches with ID's to deleted.
update Batch
set State = 9
where ID IN ('C576DF15-8479-4FBF-ACB4-02A3452254F8','6614CA0D-C1D6-4266-B762-067B17FFBFFD')
Helpful Links: Document Link