DeleteSDI
Description:
Deletes one or more SDIs from the database.
Input Properties
sdcid
Description:
Identifier of the SDC.
Required:
Yes
keyid1
Description:
Identifiers of the SDIs.
Required:
Yes
keyid2
Description:
Identifiers of the SDIs.
Required:
Only for multi-key SDCs.
keyid3
Description:
Identifiers of the SDIs.
Required:
Only for multi-key SDCs.
auditreason
Description:
Auditing information recorded in the "Reason" column of the TraceLog table.
Required:
No
auditactivity
Description:
Auditing information recorded in the "Activity" column of the TraceLog table.
Required:
No
auditsignedflag
Description:
Auditing information recorded in the "SignedFlag" column of the TraceLog table.
Required:
No
auditdt
Description:
Auditing information recorded in the "ModDt" column of the TraceLog table.
Required:
No
eventnotify
Description:
Determines whether or not (Y/N) an EventNotify Action is posted onto the ToDo List when this Action executes.
Deprecated:
As of version 7, Event Notify actions are no longer generated
applylock
Description:
Determines whether or not (Y/N) data are locked during Action processing.
Required:
No
allowdeleteinactive
Description:
Allow deletion (Y/N) of inactive or hidden SDIs. If No, the action will fail for SDIs that have a value of 'N' in the activeflag column.
Required:
No
Additional Information
Additional information concerning this Action:
To delete multiple SDIs, use this example as a guideline:

sdcid = Sample
keyid1 = S01;S02;S03
This would delete Samples S01, S02, and S03 from the application/database.

Use with caution as there are no recovery options without restoring data from a database backup! This is a hard delete.

This Action affects the tables included in the SDC identified as 'SDCID'. However, it can also remove or affect SDIs in other tables depending upon links associated with the SDI being deleted.

Copyright © 1999-2025 LabVantage Solutions, Inc.