ExtendDataSet
Description:
Adds new Data Items 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
replicateid
Description:
Replicate number of the Parameter.
Required:
Yes
applylock
Description:
Determines whether or not (Y/N) data are locked during Action processing.
Required:
No
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 replicateid = 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).
    • These rules also apply when specifying values for other columns in the SDIDataItem table.
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
numreplicate
Description:
Number of Replicates to be added.
Required:
Yes
Comments:
If you want to add Replicates of the new Parameter, specify the total number of Data Items you want to create in the SDIDataItem table. For example, if you want a total of 3 Data Items having the Parameter Al, specify numreplicate = 3. The replicateid column in the SDIDataItem table will then contain the 3 Data Items, i.e.,
paramid = Al, replicateid = 1
paramid = Al, replicateid = 2
paramid = Al, replicateid = 3
separator
Description:
Character used to separate multiple values. The default is a semicolon.
Required:
No
Comments:
For backward-compatibility, the Action code also accepts "delimiter" as the Property Id.
Additional Information
Additional information concerning this Action:
  • The Parameter must not already exist in the Data Set.
  • This Action lets you specify the number of Replicates you want when adding a new Parameter to a Data Set. However, if you want to add Replicates of a Parameter that already exists in the Data Set, use the AddReplicate Action instead.
  • For each Parameter in a Data Set, this Action lets you enter values for all other non-Core columns in the SDIDataItem table. This lets you specify Parameter List information for each Data Item.
  • For each SDIDataItem column, add a property, then use the columnid as the Property Id for the Action. For example, you could add the mandatoryflag property and set it to Y.
Copyright © 1999-2016 LABVANTAGE Solutions, Inc.