Recommended way to delete Tasks and Cases in Axon Ivy

ikdb

What is the recommended and supported way to remove Tasks and Cases in Axon Ivy?

For example, if I want to delete all Tasks and Cases created today, is it sufficient to delete the records directly from the IWA_CASES/Tasks database, or are there additional dependencies that must be handled?

Alternatively, is it better practice to:

change the state of the Case/Task (e.g. finished, destroyed, terminated).
As part of an investigation, I tried the following approaches in a development environment:

setting the state of Tasks and Cases to DESTROYED (state = 7) in the database

deleting all Tasks and Cases created today directly from the IWA_TASK and IWA_CASE tables

However, even after performing these actions, the Tasks and Cases are still visible in the system/UI, or appear to be recreated.
Thank you for your guidance.

NamChu

hi @ikdb
You should NEVER directly alter Axon Ivy system database, use API instead
In your case, you should query them then delete using API
For example if you want to delete today tasks you may do this
public static void destroyTodayTasks(){ Sudo.get(() -> { List<ITask> result = Ivy.wf().getTaskQueryExecutor() .getResults(TaskQuery.create().where().startTimestamp().isEqual(new Date())); for (ITask task : result) { task.destroy(); } return null; }); }