DeleteDataItem
Description:
For one or more SDIs, deletes a Data Item from a single Data Set that is associated with each SDI.
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:
Yes
paramid
Description:
Identifier of the Parameter deleted from the Data Set.
Required:
Yes
paramtype
Description:
Identifier of the Parameter Type.
Required:
Yes
replicateid
Description:
Replicate number of the Parameter. Yes
applylock
Description:
Determines whether or not (Y/N) data are locked during Action processing.
Required:
No
auditreason
Description:
Auditing information recorded in the "Reason" column of the TraceLog table.
Required
auditactivity
Description:
Auditing information recorded in the "Activity" column of the TraceLog table.
Required
auditsignedflag
Description:
Auditing information recorded in the "SignedFlag" column of the TraceLog table.
Required
auditdt
Description:
Auditing information recorded in the "ModDt" column of the TraceLog table.
Required
Additional Information
Additional information concerning this Action:
To delete multiple Data Items from corresponding Data Sets those are assigned to each SDI, use this example as a guideline:

sdcid = Sample
keyid1 = S01;S02
paramlistid = Metals;Polymers
paramlistversionid = 1;3
variantid = 2;4
dataset = 1;2
paramid = Al;HDPE
paramtype = Std;Mod
replicateid = 1;1
For both the Samples S01 and S02,, this deletes the Data Item for Parameter Al (Type=Std, Replicate=1) in the Metals Data Set (Version=1, Variant=2, DataSetNumber=1). And the Data Item for Parameter HDPE (Type=Mod, Replicate=1) in the Polymers Data Set (Version=3, Variant=4, DataSetNumber=2).

To delete a single Data Item from a single Data Set that is assigned to each SDI, use this example as a guideline:

sdcid = Sample
keyid1 = S01;S02
paramlistid = Metals
paramlistversionid = 1
variantid = 2
dataset = 1
paramid = Al
paramtype = Std
replicateid = 1
For both the Samples S01 and S02, this deletes the Data Item for Parameter Al (Type=Std, Replicate=1) in the Metals Data Set (Version=1, Variant=2, DataSetNumber=1).

Copyright © 1999-2016 LABVANTAGE Solutions, Inc.