EditSDIDataRelation
Description:
-
Edits records in the SDIDataRelation table.
Input Properties
sdcid
Sapphire Data Collection
keyid1
Description:
-
Identifier of the SDC.
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.
tosdcid
Description:
-
Identifier of the of the SDC related to the "Sample".
Required
tokeyid1
Description:
-
Identifiers of the SDIs for the "tosdcid" property.
Required:
-
No
tokeyid2
Description:
-
Identifiers of the SDIs for the "tosdcid" property.
Required:
-
No
tokeyid3
Description:
-
Identifiers of the SDIs for the "tosdcid" property.
Required:
-
No
refsdcid
Description:
-
Identifier of the SDC referenced by the Sample.
Required:
-
No
refkeyid1
Description:
-
Identifiers of the SDIs for the "refsdcid" property.
Required:
-
No
refkeyid2
Description:
-
Identifiers of the SDIs for the "refsdcid" property.
Required:
-
No
refkeyid3
Description:
-
Identifiers of the SDIs for the "refsdcid" property.
Required:
-
No
paramlistid
Description:
-
Identifiers of the Parameter Lists.
Required:
-
Yes
paramlistversionid
Description:
-
Parameter List Versions.
Required:
-
Yes
variantid
Description:
-
Parameter List Variants.
Required:
-
Yes
dataset
Description:
-
Data Set number.
Required:
-
Yes
amount
Description:
-
Numeric quantitity.
Required:
-
No
amountunits
Description:
-
Quantity units.
Required:
-
No
amountunitstype
Description:
-
Determines whether the amount is specified in Containers (C) or Units (U).
Required:
-
No
relationid
Description:
-
Relation Id that is part of the primary key for this table.
Required:
-
Yes
relationtype
Description:
-
Relation Type in the SDIDataRelation table.
Required:
-
No
relationfunction
Description:
-
Relation Function in the SDIDataRelation table.
Required:
-
No
applylock
Description:
-
Determines whether or not (Y/N) data are locked during Action processing.
Required:
-
No
rsetid
Description:
-
Identifier of the RSet that is passed into this Action.
Required:
-
No
Comments:
-
This is useful if you have created an RSet in another Action and want to use those values in this Action.
For example, suppose you have created an RSet in Action-001, and the Rset contains SDCId and KeyId values from multiple SDIs. You want to pass these values into Action-007. Rather than specifying all of these values in Action-007, you can simply specify the RSetId from Action-001.
An added advantage is that if data are locked in the Action-001 RSet, they will be locked in Action-007 as well.
propsmatch
Determines haow the Action handles multi-value properties:
Y = Associates each property with each SDI in the order specified.
N = Associates all properties with all SDIs.
Required:
-
No
sourcekeyid1
Description:
-
Identifiers of the source sdi.
Required:
-
No
sourcekeyid2
Description:
-
Identifiers of source sdi.
Required:
-
No
amountadjusted
Description:
-
Identifiers of Adjusted Amount.
Required:
-
No
instrumentid
Description:
-
Identifiers of Instrument ID.
Required:
-
No
Additional Information
Additional information concerning this Action:
-
None.
Copyright © 1999-2025 LabVantage Solutions, Inc.