Precisely Enterworks

 View Only

  • 1.  Using Business Keys Which Are Not PK

    Posted 02-09-2021 13:07

    I have a scenario in a profile where the "Is Business Key" is checked and "Business Key No Duplicate Option:  No duplicates" is selected.  However, this attribute is not part of the primary key.  The PK for this repo is a auto generated ID defined as BIGINT.  

    I was expecting some notification/signal if duplication among Business Key exists.  However, this is not the case as there is no signal by the system for this.  



    ------------------------------
    Jeff Wiedemann | Engineer, Apps
    Steelcase, Inc | 616-460-0597
    ------------------------------


  • 2.  RE: Using Business Keys Which Are Not PK

    Employee
    Posted 03-12-2021 03:23
    Jeff,

    The business key designation is only in an import, IF you select the option to Use Business Key.  Then if it encounters duplicates, they will be flagged.  If all records must have unique business keys, then a Bulk Callout validation rule should be defined on them, flagging any duplicates.

    -Brian

    ------------------------------
    Brian Zupke | Senior Technical Support Engineer
    Winshuttle North America | 9099009179
    ------------------------------