UndoSDIColumnValue
Description:
-
Reverts an altered value in an SDI column to its previous value.
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.
statuscolumn
Description:
-
Identifier of the status column to be updated with the previous value.
Required:
-
Yes
validatestatuscolumnvalue
Description:
-
Identifier of the validate status column value,the current column value(status) of the SDI(s) are validated against the value specified.
Required:
-
Yes
defaultvalue
Description:
-
Identifier of the default value, if previous value cannot be obtained from the audit table,the SDIs are updated with the default value in their status column.
Required:
-
No
paramlistid
Description:
-
Identifier of the Parameter List.
Required:
-
No
paramlistversionid
Description:
-
Parameter List Version.
Required:
-
No
variantid
Description:
-
Parameter List Variant.
Required:
-
No
dataset
Description:
-
Data Set Number.
Required:
-
No
workitemid
Description:
-
Identifiers of the Workitems.
Required:
-
Yes
workiteminstance
Description:
-
Identifiers of the Workitem Instance.
Required:
-
Yes
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
propsmatch
Description:
-
Determines how the Action handles multi-value properties.
Required:
-
No
Comments:
-
Example:
sdcid = Sample
keyid1 = S01;S02
workitemid = Metals;Polymers
workiteminstance = 3;6
If propsmatch = Y, this Action undo status for WorkItem instance Metals;3 for Sample S01 and Workitem instance Polymers;6 to Sample S02.
If propsmatch = N, this Action undo both WorkItem instances (Metals;3 and Polymers;6) for each Sample (S01 and S02).
Same concept applies for datasets
rollupstatus
Control roll up to upper level
* @req No, default 'Y'
Additional Information
Additional information concerning this Action:
-
None.
Copyright © 1999-2025 LabVantage Solutions, Inc.