How to delete Duplicates (in DB) - BEXIS2/Core GitHub Wiki

Delete duplicates

  1. Important: Do not change or delete directly in the database without a current backup!
  2. Important: Only delete new added tuples (not changed once!)

Check for Duplicates

  • Use BEXIS API DataQualityOut: GET /api/DataQuality/{id}
  • Look for an identical variable combination

Table mvDATSETID

  • Search for affected IDs based an identical variable combination
  • collect always highest ID

Table datatuples

  • Delete collected IDs

Update materialized view

  • Click on "snyc" under Manage Datasets