SetDataItemDate
Description:
Enters a date value into a Data Item 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
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 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
paramid = Al;HDPE
paramtype = Std;Mod
replicateid = 1;1
columnid = COL1;COL2
If propsmatch = Y, this would do the following for each Sample:
Sample S01 - Change the value in the COL1 column for Parameter Al (Type=Std, Replicate=1) in the Metals Data Set (Version=1, Variant=2, DataSetNumber=1).
Sample S02 - Change the value in the COL2 column (to Y103) for Parameter HDPE (Type=Mod, Replicate=1) in the Polymers Data Set (Version=3, Variant=4, DataSetNumber=2).
If propsmatch = N, this would change the value in both COL1 and COL2 for both Parameters 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 dataitem columns to edit.
Required:
Yes
value
Description:
Values to enter into the columns.
Required:
Yes
Additional Information
Additional information concerning this Action:
  • This Action does not update these columns in the SDIDataItem table:
    auditsequence, createby, createdt, createtool, dataset, displayvalue, enteredoperator, enteredqualifier, enteredtext, enteredunits, enteredvalue, keyid1, keyid2, keyid3, modby, moddt, modtool, paramid, paramlistid, paramlistversionid, paramtype, replicateid, sdcid, textcolor, tracelogid, transformdt, transformtext, transformvalue, valuestatus, variantid.
  • 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.
  • 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.

This Action affects the SDIDataItem table.

Copyright © 1999-2016 LABVANTAGE Solutions, Inc.