SetDataSetNumber
Description:
Enters a numeric value into a Data Set column.
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
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.
Required:
No
Comments:
Example of propsmatch:
sdcid = Sample
keyid1 = S01;S02
paramlistid = Metals;Polymers
paramlistversionid = 1;3
variantid = 2;4
dataset = 1;2
columnid = COL1;COL2
If propsmatch = Y, this would do the following for each Sample:
Sample S01 - Change the value in the COL1 column in the Metals Data Set (Version=1, Variant=2, DataSetNumber=1).
Sample S02 - Change the value in the COL2 column (to Y103) in the Polymers Data Set (Version=3, Variant=4, DataSetNumber=2).
If propsmatch = N, this would change the value in both COL1 and COL2 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
columnid
Description:
Identifiers of the dataset columns to edit.
Required:
Yes
value
Description:
Values to enter into the columns.
Required:
Yes
Additional Information
Additional information concerning this Action:
If you add columns to the Parameter List SDC, Sapphire will not copy-down values in the added columns to the Data Set level. Sapphire copies down only Core columns.
Copyright © 1999-2016 LABVANTAGE Solutions, Inc.