AddSDIDetail
Description:
Adds new records to a Detail table of an SDC or a detail of a detail.
Input Properties
sdcid
Description:
Identifier of the SDC to which the detail table applies.
Required:
Yes
keyid1
Description:
Identifiers of the SDIs in the detail table for which you want to add the record.
Required:
Yes
keyid2
Description:
Identifiers of the SDIs in the detail table for which you want to add the record.
Required:
Only for multi-key SDCs.
keyid3
Description:
Identifiers of the SDIs in the detail table for which you want to add the record.
Required:
Only for multi-key SDCs.
linkid
Description:
Link Text that describes the Detail Link in the SDCLink table.
Required:
Yes
detaillinkid
Description:
Link Text that describes the Detail Link in the SDCDetailLink table.
Required:
No
applylock
Description:
Determines whether or not (Y/N) data are locked during Action processing.
Required:
No
eventnotify
Description:
Determines whether or not (Y/N) an event is posted on the ToDo List when the Action executes.
Deprecated:
As of version 7, Event Notify actions are no longer generated
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 Detail Table can be a Detail of an SDC (using the "linkid" property) or a Detail of a Detail (using the "detaillinkid" property). For example:
sdcid = LV_EVENTDEF (this is the s_eventdef table)
linkid = s_eventdefsampletype (this is the detail link)
detaillinkid = s_eventdefstspecimendef; s_eventdefstatworkitemmap (these are the details of the detail)

To insert data into the table defined by the "linkid" property, specify values for sdcid, keyid(1,2,3), and linkid.

To insert data into the table defined by the "detaillinkid" property, specify values for sdcid, keyid(1,2,3), linkid, and detaillinkid. If "detaillinkid" is passed as an argument to the Action, the Action updates the two detaillinktables: s_eventdefstspecimendef and s_eventdefstatworkitemmap.

Example of a detail of the specified SDC:
A record is added to the detail for each SDI. Add properties to specify the record. The example below adds Parameter Cu to the Metals Parameter List. This is actually adding the Cu record to the ParamListItem table. You must always add properties to specify values needed for the operation you want to perform. In the example below, adding just the paramid Cu and paramtype Standard will add Cu to the Metals Parameter List. However, if you want to enter data for this Parameter, you must also specify the data type (this is numeric data, so datatype = N), the Replicate number (numreplicates = 1), and whether or not data entry is mandatory for that Parameter (mandatoryflag = Y).

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

Add these properties:
paramid = Cu
paramtype = Standard
datatype = N
numreplicates = 1
mandatoryflag = Y



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

Add these properties:
paramid = Sodium;Calcium;Cesium;Francium
paramtype = Standard;Standard;Standard;Standard



Also we can pass auditreason, auditactivity, auditsignedflag as arguments to this action as below
auditreason=Add parameters
auditactivity=Add
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.