Removing Clinical Data API status records
You can use the XmlSubmitPurgeRecords stored procedure, which exists in the study schema, to remove Clinical Data API status records that were submitted prior to a specified date.
- To execute XmlSubmitPurgeRecords, use the following syntax:
XmlSubmitPurgeRecords (LastProcessingDate IN DATE)
where:
- IN DATE—Parameter you need to pass the command. Specify a date in the IN DATE parameter, and the XmlSubmitPurgeRecords procedure removes the status records that were submitted before that date.
The date must use the format yyyy-mm-dd hh:mm:ss. For example, to remove status records prior to February 28, 2014 at 12:30 pm, enter 2014-02-28 12:30:00.
- IN DATE—Parameter you need to pass the command. Specify a date in the IN DATE parameter, and the XmlSubmitPurgeRecords procedure removes the status records that were submitted before that date.
Note: If you run the XmlSubmitPurgeRecords stored procedure, you cannot access detailed information regarding individual status records prior to the date you entered in the IN DATE parameter. You can access only a summary of submits.