AddReplicate
Description:
Adds Replicates to SDI Data Sets.
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
numreplicate
Description:
string Number of Replicates to be added.
Required:
No
Comments:
This Action automatically generates the replicateid by incrementing to the next Replicate number. From the highest number Replicate that already exists in the Data Set, this Action copies the Parameter List definition and all other related information from the SDIDataItem, SDIDataItemLimit, and SDIDataItemSpec tables.
For example, if the Data Set contains one Data Item having the Parameter Al, and you want to add two more, specify 2 Replicates. The replicateid column in the SDIDataItem table will then contain the original Parameter, plus the 2 Replicates you requested:

paramid = Al     replicateid = 1
paramid = Al     replicateid = 2
paramid = Al     replicateid = 3

propsmatch
Description:
Determines how multiple property values are associated with SDIs.
Required:
Yes
Comments:
As an example, consider these properties:

sdcid = Sample
keyid1 = S01;S02
paramlistid = Metals;Polymers
paramlistversionid = 1;4 variantid = 2;5 dataset = 3;6 paramid = Al;HDPE paramtype = Std;Mod numreplicate = 2;3 The propsmatch value has these effects:

  • propsmatch = Y:
    Adds 2 Replicates of Parameter Al;Std to Data Set Metals;1;2;3, then adds this Data Set to Sample S01.
    Adds 3 Replicates of Parameter HDPE;Mod to Data Set Polymers;4;5;6, then adds this Data Set to Sample S02.
  • propsmatch = N:
    Adds both sets of Parameters (2 Replicates of Al;Std and 3 Replicates of HDPE;Mod) to each Data Set (Metals;1;2;3 and Polymers;4;5;6).
    Adds both Data Sets to each Sample (S01 and S02).
applylock
Description:
Determines whether or not (Y/N) data are locked during Action processing.
Required:
No
separator
Description:
Character used to separate multiple values. The default is a semicolon.
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:
Records the date entered for this property in the ModDt column of the TraceLog table.
Required:
No
Additional Information
Additional information concerning this Action:
The Parameter must already exist in the Data Set. If you want to add Replicates of Parameters that do not exist in the Data Set, use the ExtendDataSet Action instead.
Copyright © 1999-2016 LABVANTAGE Solutions, Inc.