Jump to: navigation, search

Difference between revisions of "HowTo:Hard delete database records"


(Created page with "Since {{UBIK}} 4.3, it is possible to hard-delete records from the database to avoid it growing endlessly. <!-- DO NOT REMOVE THIS -->{{Template:HowTo/Begin}}<!-- DO NOT REMO...")
 
 
Line 21: Line 21:
 
The overloads of the hard-delete method allow for removal of records that were marked as deleted before a given date, or from a range of specific IDs (again, of already deleted objects).
 
The overloads of the hard-delete method allow for removal of records that were marked as deleted before a given date, or from a range of specific IDs (again, of already deleted objects).
  
<!-- ==See also== -->
+
==See also==
 
<!-- DO NOT MODIFY THE NAME OF THIS SECTION, BUT REMOVE IT IF NOT REQUIRED -->
 
<!-- DO NOT MODIFY THE NAME OF THIS SECTION, BUT REMOVE IT IF NOT REQUIRED -->
 +
* [[Version_4.3.0_(Server)#Features|Release notes for {{UBIK}} version 4.3]]
  
[[Category:How-To|Hard delete database records]]
 
 
[[Category:Coding|Hard delete database records]]
 
[[Category:Coding|Hard delete database records]]
 
[[Category:Database|Hard delete database records]]
 
[[Category:Database|Hard delete database records]]
 +
[[Category:How-To|Hard delete database records]]
 
[[Category:Studio|Hard delete database records]]
 
[[Category:Studio|Hard delete database records]]

Latest revision as of 11:12, 11 April 2025

Since UBIK® 4.3, it is possible to hard-delete records from the database to avoid it growing endlessly.


[edit]

Instructions

  1. Delete objects regularly.
  2. Perform a hard-delete operation.

The hard-delete operation is available for programmatic customizing or execution via Who-Bert on the server side. A set of methods for hard-deleting objects from the database is now available in the IDataFactory interface:

bool HardDeleteRecords(MetaClass mc, DateTime? markedBefore = null);
bool HardDeleteRecords(MetaClass mc, List<Guid> idsToDelete);

E.g.:

environment.UBIKDataFactory().HardDeleteRecords(metaclass);

The overloads of the hard-delete method allow for removal of records that were marked as deleted before a given date, or from a range of specific IDs (again, of already deleted objects).

See also