Delete batches in date range : PIF Technologies

Delete batches in date range Print

Modified on: Mon, 27 Dec, 2021 at 1:07 PM

Software (include version): Ancora, DocStar IDC, Epicor IDC

Use Case: Needed to set the batches that fall between this date range to deleted. The following can be modified to set the batch state to 9 (deleted)

Customer: N/A

Prerequisites: Determine date range by using Admin / batches

Instructions:

Run the following SQL statement to update the batches in the defined date range (dates listed below are examples, please adjust to your desired range
1. UPDATE [docstarIdcServerDb].[dbo].[Batch] set state = 9 where createdon BETWEEN cast('01/01/2021' as datetime) AND cast ('04/20/2021' as datetime)

Helpful Links:

Did you find it helpful? Yes No

Delete batches in date range Print