AddDataItem
Description:
Adds existing Parameters 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:
Identifiers of the Parameter Lists.
Required:
Yes
paramlistversionid
Description:
Identifiers of the Parameter List Versions.
Required:
Yes
variantid
Description:
Identifiers of the Parameter List Variants.
Required:
Yes
dataset
Description:
Data Set Numbers.
Required:
Yes
paramid
Description:
Identifiers of the Parameters added to the Data Set.
Required:
Yes
paramtype
Description:
Identifiers of the Parameter Types.
Required:
Yes
replicateid
Description:
Identifiers of the Parameter Replicates.
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:
To demonstrate use of this property for all Actions that support it, here is a generic example. Consider these property values:
  • sdcid = NSAID
  • keyid1 = ibuprofen;naproxen
  • buffer = Na3PO4;CH3COONa
In this case:
  • propsmatch = Y associates each buffer with each SDI, i.e.,
    ibuprofen's buffer is Na3PO4, naproxen's buffer is CH3COONa.
  • propsmatch = N associates both buffers with each SDI, i.e.,
    both ibuprofen and naproxen use Na3PO4 and CH3COONa as buffers.
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 add.
Required:
Yes.
paramlistcheck
Description:
Determines how the Action checks each Parameter:
  • Y (default) = Checks the Parameter List and Data Set to see if the Parameter already exists in either. One of the following actions is taken based on this determination:
    • If the Parameter exists in the Parameter List but does not exist in the Data Set, the Parameter is added to the Data Set.
    • If the Parameter exists in the Data Set, the Action does nothing.
  • N = Unconditionally adds the Parameter (in the Parameter List) to the Data Set.
Required:
No
separator
Description:
Character used to separate multiple values. The default is a semicolon.
Required:
No
Additional Information
Additional information concerning this Action:
Although you can use this Action with any Sapphire version, it now exists primarily for backward-compatibility with previous Sapphire versions. Currently, the preferred method of adding Data Items to Data Sets is to use the following Actions:
  • ExtendDataSet
    Adds Parameters that do not already exist in the Data Set.
  • AddReplicate
    Adds Replicates of Parameters that exist in the Data Set.
Copyright © 1999-2016 LABVANTAGE Solutions, Inc.