EditSDI
Description:
Modifies values of existing SDI columns.
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.
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
eventnotify
Description:
Determines whether or not (Y/N) an EventNotify Action is posted onto the ToDo List when this Action executes.
Deprecated:
As of version 7, Event Notify actions are no longer generated
applylock
Description:
Determines whether or not (Y/N) data are locked during Action processing.
Required:
No
Additional Information
Additional information concerning this Action:
  • For each column to be edited, add a property with an identifier that is identical to column name, then set the value of the property.
  • To write a single value or multiple values into the same column across multiple SDIs, use these examples as guidelines:

    sdcid = Sample
    keyid1 = S01;S02;S03
    projectid = Polymers
    customerid = UnitedPlastics
    This enters Polymers into the projectid column of Samples S01, S02, and S03, and UnitedPlastics into the customerid column of Samples S01, S02, and S03.

    sdcid = Sample
    keyid1 = S01;S02;S03
    projectid = Polymers;Fluids;Solids
    customerid = UnitedPlastics;BrandXMilk;NakaSteel
    locationid = USA;UK;Japan
    This enters Polymers, UnitedPlastics, and USA for Sample S01; Fluids, BrandXMilk, and UK for Sample S02, and Solids, NakaSteel, and Japan for Sample S03.

    sdcid = Sample
    keyid1 = S01;S02;S03
    projectid = Polymers;Fluids
    If you specify more SDIs than values, the remainding columns are assigned null values. This enters Polymers as the projectid for Sample S01 and Fluids as the projectid for Sample S02. The projectid column of Sample S03 is assigned a null value.

This Action affects records in the SDC table.

Copyright © 1999-2016 LABVANTAGE Solutions, Inc.