Truncate Work Flow Tasks in BPEL

Why I want to do this?

While in Development, the instances are purged using the "Purge All Instances" option button in Instances tab in BPEL console.

What I find is this process does not seem to clear out any work flow tasks that are outstanding.

How I do this

To clean out all the outstanding WF tasks use the following query.

=============Query START ===================
truncate table wftaskhistory;
truncate table wfassignee;
truncate table wfattachment;
truncate table wfcomments;
truncate table wfmessageattribute;
truncate table wfnotification;
truncate table wfnotificationmessages;
truncate table wfroutingslip;
truncate table wftasktimer;
truncate table wftask;
=============Query END ===================

What it does?

What this does is clear the back end BPEL database table.