Delete import batch

<< Click to Display Table of Contents >>

Navigation:  Technical documentation > Importing data > Import contexts >

Delete import batch

Previous pageReturn to chapter overviewNext page

If the client wants to undo a certain import, it is possible by using the BatchId returned in the call to OpenImportContext.  Note that it is only possible to rollback the current batch using this procedure.  The reason for this is that data imported from a different source later may have been prevented from updating a datapoint because the import function automatically discards duplicate data.


EXEC DeleteImportBatch 3444


The call to this procedure may take some time to complete, as many rows of data may have to be deleted from multiple tables.  The data is deleted with a foreign key with cascading deletes.  Deleting a row in the ImportBatch table may causes cascading deletes for data in LabData, ClinProblem and DrugTreatment.