Answer by Reguel Wermelinger

Reguel Wermelinger — Fri, 01 Apr 2016 11:34:06 -0400

Delete Tasks and Cases in Xpert.ivy 3.9

via Workflow Admin UI

Workflow Administrators can delete tasks and cases within a date range over the administration UI.

via SystemDB

Sample query to select taskIds which will be destroyed. Rewrite it to a DELETE statement to really remove the data.

SELECT d.TaskId
  FROM IWA_TaskData as d
  JOIN IWA_Task as t ON d.TaskId = t.TaskId
  WHERE t.State IN (6,7) /** delete only done and destroyed tasks **/
  AND d.TaskDataKind = 1; /** delete only start data, keep current data **/
  AND t.DoneTimestamp = XYZ /** limit the date: only delete data older than 3 years or similar **/

Answer by Tamas KIS

Tamas KIS — Thu, 26 Sep 2013 02:56:36 -0400

There are two ways to do this, one directly in the system DB and one with an API call.

Delete via Public API

you can build a process/App around the Public API: void deleteCompletedCase(ICase completedCase) throws PersistencyException

A simple script which deletes old cases could look as follows:

public class HistoricCaseDeleter {
    public static void doIt()
    {
        CaseQuery oldCasesQuery = CaseQuery.create().where()
            .state().isEqual(CaseState.DESTROYED).or()
            .state().isEqual(CaseState.DONE).or()
            .state().isEqual(CaseState.ZOMBIE)
            .and()
            .startTimestamp().isLowerThan(new java.util.Date(2010, 0, 1));

        for(ICase oldCase : Ivy.wf().getCaseQueryExecutor().getResults(oldCasesQuery))
        {
            Ivy.wf().deleteCompletedCase(oldCase);
        }
    }
}

Delete directly in System DB

You may clean up cases and tasks in Done (2) and Destroyed (3) state as follows:

Stop Axon.ivy server v4.x or later
Backup your DB (of course)
Execute to know how many cases you are about to remove:
SELECT COUNT() FROM [YourIvySystemDb].[dbo].[IWA_Case] WHERE State = 2 OR State = 3*
Execute to remove them:
DELETE FROM [YourIvySystemDb].[dbo].[IWA_Case] WHERE State = 2 OR State = 3
You may shrink your DB to save disk space (e.g. MSSQL manager tool can do that)
Start Axon.ivy server again

Answers to: How to cleanup old Cases / Tasks?

Answer by Reguel Wermelinger

Answer by Tamas KIS