Examples

  • To delete audit entries or statistical data of process instances for template IDs 1, 3, 5, and 7 (= ec_proc_template.id), that have completed, cancelled, or failed before the specified date, and that do not have any active, detached sub-process instances:
    CALL EC_DELETE_AUDIT_STATS_DATA('1, 3, 5, 7', '2011-11-01 10:42:01.008’);
  • To delete audit entries of process instances for all templates, that completed, cancelled, or failed before the specified date, including data for any detached sub-process instances that are still active:
    CALL EC_DELETE_AUDIT_STATS_DATA(NULL, '2011-11-01 10:42:01.008’, NULL, TRUE);
  • To delete all audit entries of process instances for template IDs 1, 3, 5, and 7 (= ec_proc_template.id):
    CALL EC_DELETE_AUDIT_STATS_DATA('1, 3, 5, 7');
  • To delete audit entries for all completed, cancelled, or failed process instances:
    CALL EC_DELETE_AUDIT_STATS_DATA();
  • To delete audit entries for all completed, cancelled, and failed process instances with a different commit batch size (for example 150):
    CALL EC_DELETE_AUDIT_STATS_DATA(NULL, NULL, 150);