EditDataItem
Description:
For a specified Data Item, changes the value of a column you have added to the DataItem SDC.
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.
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
propsmatch
Description:
Determines how the Action handles multi-value properties. Y = Edits each Data Set associated with each SDI.
N = Edits all columns for all Parameters in all Data Sets associated with all SDIs.
Required:
No
Comments:
Example:
sdcid = Sample
keyid1 = S01;S02
paramlistid = Metals;Polymers
paramlistversionid = 1;4
variantid = 2;5
dataset = 3;6
paramid = Al;HDPE
paramtype = Std;Mod
replicateid = 1;1
controlcode = X204; Y103
If propsmatch = Y, this does the following for each Sample:
Sample S01 - Change the value in the Control Code column (to X204) for Parameter Al (Type=Std, Replicate=1) in the Metals Data Set (Version=1, Variant=2, DataSetNumber=1).
Sample S02 - Change the value in the Control Code column (to Y103) for Parameter HDPE (Type=Mod, Replicate=1) in the Polymers Data Set (Version=3, Variant=4, DataSetNumber=2)
If propsmatch = N, this would change the value in both Control Code columns for both Parameters in both Data Sets for both Samples.
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 edit Data Item columns for multiple SDIs, use the following 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
controlcode = X204;Y103
For Sample S01, this changes the controlcode column value for Parameter Al (Type=Std, Replicate=1) in the Metals Data Set (Version=1, Variant=2, DataSetNumber=1).
For Sample S02, this changes the controlcode column value for Parameter HDPE (Type=Mod, Replicate=1) in the Polymers Data Set (Version=3, Variant=4, DataSetNumber=2).

Copyright © 1999-2016 LABVANTAGE Solutions, Inc.