Precisely Enterworks

 View Only
  • 1.  Deleting a Record from Production

    Posted 01-10-2022 10:19
    I'm just wondering how others handle deletes made in Staging/Promotion configured repositories?  Especially in the context of a Package Promotion set of repositories.

    In our example we have Package Promotion configured for a Product, SKUs, and Parcels, along with some various other supporting repos and link repositories.  If a user deletes a Parcel from a SKU and adds a new Parcel record, then promotes the Product Package.  The new records are promoted (including the new SKU to Parcel Link and the new Parcel).  But the issue we face is that the Production repositories now show a link from the SKU to the old Parcel as well as the new Parcel.

    So how do others handle "deleting" Production repository records?  Somehow with a Change Notification trigger?  Maybe scheduled jobs?  Is it maybe best practice to not delete the record and handle it with some sort of "status" attribute?

    Thanks!
    Josh

    ------------------------------
    Joshua Swett | Sr Applications Engineer
    Steelcase, Inc | 2696251984
    ------------------------------


  • 2.  RE: Deleting a Record from Production

    Posted 01-10-2022 16:19
    I actually found a great Brown-Bag Session (#88) on the Winshuttle E-Learning site.  Lots of good options for deleting related production records there!

    ------------------------------
    Joshua Swett | Sr Applications Engineer
    Steelcase, Inc | 2696251984
    ------------------------------