cascade-delete
Reactive icon

Cascade Delete

Stable version 1.0.2 (Compatible with OutSystems 11)
Uploaded
 on 8 Aug
 by 
5.0
 (6 ratings)
cascade-delete

Cascade Delete

Details
This asset is a powerful tool designed to simplify the deletion of data from one or more OutSystems database entities. Its primary purpose is to facilitate the purging of testing data generated during the development and testing phases of an application. This application addresses the challenges and complexities associated with reliably purging databases.
Read more

The key feature of the Cascade Delete App is its ability to create "Delete-Groups." These groups comprise of original selected entities to be deleted by the user, and automatically include all dependent entities based on their foreign key references. The app utilizes?the OutSystems system entities?to determine foreign key relationships, eliminating the need for developers to manually specify dependent entities and their deletion order. This "cascade" effect simplifies the entire process, saving substantial setup time compared to traditional approaches.?For a more detailed explanation of the dependent entities, see the Documentation section. 

Features: 

  • Create Unlimited Delete-Groups: Effortlessly set up complex database purges in minutes. 

  • Automatic Maintenance of Delete-Groups: Dynamically update dependencies to avoid foreign key constraint errors.? 

  • Custom Scheduling: Reuse Delete-Groups on demand or create custom schedules for purges.?Schedule can be set to run Once off, Daily, Weekly, Monthly or a combination of these.   

  • Ease of Entity Selection: Easily add or remove entities from across the environment. Copy existing Delete-Groups to speed up the process for similar purges. ? 

  • Timeout-Free Purging: Delete substantial data without worrying about timeouts, thanks to self-awakening timers.? 

  • Auditing and History Tracking: Track all interactions, deletions, and their details for comprehensive auditing.? 

  • User-Friendly Interface: Avoid unexpected data deletion with a friendly UI displaying all entities to be deleted.? 

  • Central Console: A centralized platform for all data purging needs, including audit and history tracking.? 

  • Manual Kill Switch: Accessible via the service centre to stop and roll back a delete if needed.? 

  • Multi-User Support: Allows multiple users to request deletes simultaneously, queuing them automatically.? 

  • Live Progress Tracking: Track the real-time status of delete progress, showing which entities have been deleted, which have failed, and why.? 

Disclaimer: 

Given this application's capacity for permanent deletion of significant data volumes, exercise utmost care in its usage. Any customizations should be approached with meticulous attention to prevent unintentional data loss. If users choose to modify the application, they are responsible for any resulting issues. 

By utilizing this application, users acknowledge and assume full responsibility for its use. Systems iO is not liable for any unintended data loss, including but not limited to misuse or application malfunction. The application may be updated or modified at any time, and users are expected to use only stable versions. Use of this application implies acceptance of these terms. 

Release notes (1.0.2)
  1. Upgraded to the latest OutSystems UI
  2. Minor UI fixes made necessary by upgrade to the latest OutSystems UI
  3. Minor UI/UX improvements
  4. Bug when saving a new Delete Group and then deleting it without leaving/refreshing the screen fixed
  5. Decreased Tech Debt throughout the app. Noticeable changes include:
    1. Introduced a new Site Property, MaxRecordsOnAggregate, to set the maximum number records returned on several of the Aggregates. This defaults to 100000.
    2. Reduced the Module default timeout of the front end from 120 seconds to 30 seconds. This was possible since the actual delete logic runs in a Timer and is thus asynchronous. If you find that this is too low and the connection is timing out, simply increase to suit your use case.
License (1.0.2)
Reviews (5)
by 
9 May
in version 1.0.1
Awesome app to clear testing data - helps to clear dirty data when fixing bugs in your application. 
by 
8 May
in version 1.0.1
A helpful tool for getting rid of loads of test data at once 
by 
8 May
in version 1.0.1
Great component! Easy to use
Team
Other assets in this category