EditSDIDetail
Description:
Modifies one or more records in a Detail table of an 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.
linkid
Description:
Link Text that describes the Detail Link. This is specified in the SDCLink table.
Required:
Yes
applylock
Description:
Determines whether or not (Y/N) data are locked during Action processing.
Required:
No
separator
Description:
Allows the use of custom seperators other than semicolon (;). If not specified then will default to semi-colon (;).
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
Additional Information
Additional information concerning this Action:
The example below changes the Display Units of Parameter Cu in the Metals Parameter List from its current value to degC. This is actually overwriting the value in the ParamListItem table.

For single record:
sdcid = ParameterList
keyid1 = Metals
keyid2 = 1
keyid3 = 1
linkid = paramlistitems

Add these properties:
paramid = Cu
paramtype = Standard
displayunits = degC



For multiple records:
sdcid = ParameterList
keyid1 = Assay;Assay;Metals;Metals
keyid2 = 1;1;1;1
keyid3 = 1;1;1;1
linkid = paramlistitems

Edit these properties:
paramid = Sodium;Calcium;Cesium;Francium
paramtype = Standard;Standard;Standard;Standard
displayunits = degC1;degC2;degC3;degC4



Also we can pass auditreason, auditactivity, auditsignedflag as arguments to this action as below
auditreason=Edit parameters
auditactivity=Edit
auditsignedflag=N

Note: Other advanced properties include the use of separator to allow lists of properties to be separated by other strings other than semicolon and the use of __[coreproperty] (where [coreproperty] is either keyid1, keyid2, keyid3 or sdcid) to update the corresponding detail rows that have these columns while still allowing the primary properties to be passed.
Copyright © 1999-2016 LABVANTAGE Solutions, Inc.