Syncing Record Deletions

  • Updated on May 9, 2020
  • Published on May 9, 2020
  • 1 minute(s) read
  • Nate Brock
 Prev Next

Introduction

Deleting data is a very sticky and tricky topic. There are very specific requirements that must be met to facilitate syncing delete activity to other devices on your haploo sync domain. We ALWAYS recommend doing soft-deletes when possible in any database solution or use more record validation during record creation to prevent the production of erroneous or incorrect records.

A few guidelines to follow

  1. Only Restricted / Limited Users may have their delete activity captured by sync. Strange Right? Trust us this will make more sense as you learn more about the platform.

  2. Full Access Users must run scripts that re-login them in as a limited user, run the delete record script step, then re-login them back as a Full Access User at the end of the script.
    image.png

  3. The limited delete calculation must be configured for each table and security privilege set where syncing delete activity is desired.

image.png

A.Example of the required Haploo Function in the Delete Limited Calc.
image.png

  1. Scripts that perform deletions on tables that require the deletion activity to sync must NOT be set with "Grant Full Access Privileges" enabled on the script.
    image.png

  2. The "Truncate Table" script set does not work. This is a special script step that requires "Full Access" privileges to execute. This is will bypass our SyncOnDelete() function found within each table / user's limited security delete calculation.