Examples
- To delete audit entries or statistical data of process instances for template IDs 1, 3, 5, and 7 (= ec_proc_template.id), and have completed, cancelled, or failed before the specified date:
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 completed, cancelled, or failed before the specified date:
CALL EC_DELETE_AUDIT_STATS_DATA((NULL, '2011-11-01 10:42:01.008’);
- 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);
Copyright © Cloud Software Group, Inc. All rights reserved.