EnterDataItem
Description:
For one or more SDIs, enters a single Data Value for a single Data Set that is assigned to each SDI.
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
enteredtext
Description:
Data Value to enter for the Data Item record.
Required:
Yes
overridereleased
Description:
Whether or not (Y/N) to override Released data. Defaults to Y.
Required:
No
applylock
Description:
Determines whether or not (Y/N) data are locked during Action processing.
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:
Auditing information recorded in the "ModDt" column of the TraceLog table.
Required:
No
eventnotify
Description:
Determines whether or not (Y/N) an EventNotify Action is posted onto the ToDo List when this Action executes.
Deprecated:
As of version 7, Event Notify actions are no longer generated
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;S03
paramlistid = Metals;Polymers;Fluids
paramlistversionid = 1;3;5
variantid = 2;4;6
dataset = 1;2;3
paramid = Al;HDPE;IPA
paramtype = Std;Mod;Unu
replicateid = 1;1;1
enteredtest = 100;200;300
If propsmatch = Y, this enters these Data Values for each Sample:
Sample S01 - 100 for the Al Parameter (Type=Std, Replicate=1) of the Metals Data Set (Version=1, Variant=2, DataSetNumber=1)
Sample S02 - 200 for the HDPE Parameter (Type=Mod, Replicate=1) of the Polymers Data Set (Version=3, Variant=4, DataSetNumber=2)
Sample S03 - 300 for the IPA Parameter (Type=Unu, Replicate=1) of the Fluids Data Set (Version=5, Variant=6, DataSetNumber=3)
If Props Match = N, this would enter these values for Samples S01, S02, and S03:
100, 200, and 300 for Al Parameter (Type=Std, Replicate=1), HDPE Parameter (Type=Mod, Replicate=1), and IPA Parameter (Type=Unu, Replicate=1) of the the Metals Data Set (Version=1, Variant=2, DataSetNumber=1), Polymers Data Set (Version=3, Variant=4, DataSetNumber=2), and Fluids Data Set (Version=5, Variant=6, DataSetNumber=3)
Additional Information
Additional information concerning this Action:
  • To enter a Data Value for multiple SDIs, use the following example as a guideline:

    sdcid = Sample
    keyid1 = S01;S02;S03
    paramlistid = Metals;Polymers;Fluids
    paramlistversionid = 1;3;5
    variantid = 2;4;6
    dataset = 1;2;3
    paramid = Al;HDPE;IPA
    paramtype = Std;Mod;Unu
    replicateid = 1;1;1
    enteredtext = 100;200;300
    For Sample S01, this enters 100 for the Al Parameter (Type=Std, Replicate=1) of the Metals Data Set (Version=1, Variant=2, DataSetNumber=1).
    For Sample S02, this enters 200 for the HDPE Parameter (Type=Mod, Replicate=1) of the Polymers Data Set (Version=3, Variant=4, DataSetNumber=2).
    For Sample S03; this enters 300 for the IPA Parameter (Type=Unu, Replicate=1) of the Fluids Data Set (Version=5, Variant=6, DataSetNumber=3).

  • Comments Concerning Limit Rules:
    When you create a Limit Rule (Link: ../base/limrulpg.htm), you can specify two Actions: one to execute when the Limit is met/not met/either, and one to execute unconditionally following the first Action. This has implications when using EnterDataItem.
    In a Web page, EnterDataItem executes as part of the Save transaction. This means that if the Action fails, the Save transaction also fails.
    In LVX, EnterDataItem does not execute as part of the Save transaction. This means that if the Action fails, the Save transaction does not.

This Action can change the values in the TransformValue, EnteredQualifier, and DisplayValue columns in the SDIDataItem table.

Copyright © 1999-2016 LABVANTAGE Solutions, Inc.