EditDataSet
Description:
For one or more SDIs, changes the value of one or more columns you have added to the DataSet 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:
no
paramlistversionid
Description:
Identifier of the Parameter List Version.
Required:
no
variantid
Description:
Identifier of the Parameter List Variant.
Required:
no
dataset
Description:
Data Set Number.
Required:
no
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
If propsmatch = Y, this Action edits Data Set Metals;1;2;3 for Sample S01 and Data Set Polymers;4;5;6 to Sample S02.
If propsmatch = N, this Action edits both Data Sets (Metals;1;2;3 and Polymers;4;5;6) for each Sample (S01 and S02).
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
createworksheet
Description:
Determines the form which would be used to create worksheet for the workitems.
Required:
No
Comments:
Only single value is accepted.
Worksheet would only be created if createworksheetrule for the Param List is 'On Creation' or 'On Assignment' and the dataset is being assigned to any analyst/dept.
If a form is passed in explicitly then it would be used, else the default form is retrieved from the Param List definition.
formid
Description:
Determines the form which would be used to create worksheet for the workitems.
Required:
No
Comments:
Only single value is accepted.
If a form is passed in explicitly then it would be used, else the default form is retrieved from the Param List definition.
formversionid
Description:
The formversionid of the form.
Required:
No
Comments:
Only single value is accepted.
assignto
Description:
Defines the user that the dataset and worksheet(if present), is assigned to.
Required:
No.
Comments:
Should be used instead of s_assignedanalyst. If both are passed in, then assignto will be given preference over s_assignedanalyst.
editincompleteonly
Description:
If 'Y', then the Completed DataSets will not be modified. Default is 'N'
Required:
No.
Additional Information
Additional information concerning this Action:
To edit Data Set 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
controlcode = X204;Y103
For Sample S01, this changes the controlcode column value for the Metals Data Set (Version=1, Variant=2, DataSetNumber=1).
For Sample S02, this changes the controlcode column value for the Polymers Data Set (Version=3, Variant=4, DataSetNumber=2).

Copyright © 1999-2016 LABVANTAGE Solutions, Inc.