DeleteDataSet
Description:
For one or more SDIs, deletes one or more Data Sets (instances of a Parameter List).
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.
paramlistid
Description:
Identifier of the Parameter List.
Required:
Yes
paramlistversionid
Description:
Identifier of the Parameter List Version.
Required:
Yes
variantid
Description:
Identifier of the Parameter List Variant.
Required:
Yes
dataset
Description:
Data Set Number.
Required:
No
Comments:
If you do not specify a value, the next highest Data Set Number is used.
applylock
Description:
Determines whether or not (Y/N) data are locked during Action processing.
Required:
No
forcedelete
Determines how the Data Set is deleted based on its contents:
  • Y (default) = Deletes the Data Set whether or not it contains data.
  • N = Does not delete the Data Set if it contains data.
Required:
No
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
Additional Information
Additional information concerning this Action:
To delete multiple Data Sets from multiple SDIs, use this example as a guideline:

sdcid = Sample
keyid1 = S01;S02;S03
paramlistid = Metals;Polymers
paramlistversionid = 1;3
variantid = 2;4
This deletes Metals (Version 1, Variant 2) and Polymers (Version 3, Variant 4) from Samples S01, S02, and S03.
If you do not specify paramlistid, paramlistversionid, variantid, and dataset, this Action deletes all Data Sets associated with the SDIs.

This Action affects the SDIData and SDIDataItem tables, and can also affect the SDIDataApproval and SDIDataItemLimits tables.

Copyright © 1999-2016 LABVANTAGE Solutions, Inc.