Hi,
In order to delete a case you can follow the information that ProcessMaker provides:
https://wiki.processmaker.com/3.0/Cases#Delete
And if you want to delete the cases manually you can make a query but its not recomended
First enter to your Database using the follow command
>> mysql -u root -p
Now, use wf_workflow
>> USE wf_workflow;
"To this example we are going to remove specific cases using their case number. This example deletes cases whose case numbers are 8, 3"
>> DELETE FROM APP_DOCUMENT USING APP_DOCUMENT INNER JOIN APPLICATION WHERE APPLICATION.APP_NUMBER IN (8, 3) AND APPLICATION.APP_UID = APP_DOCUMENT.APP_UID;
>> DELETE FROM APP_EVENT USING APP_EVENT INNER JOIN APPLICATION WHERE APPLICATION.APP_NUMBER IN (8, 3) AND APPLICATION.APP_UID = APP_EVENT.APP_UID;
>> DELETE FROM APP_MESSAGE USING APP_MESSAGE INNER JOIN APPLICATION WHERE APPLICATION.APP_NUMBER IN (8, 3) AND APPLICATION.APP_UID = APP_MESSAGE.APP_UID;
>> DELETE FROM APP_OWNER USING APP_OWNER INNER JOIN APPLICATION WHERE APPLICATION.APP_NUMBER IN (8, 3) AND APPLICATION.APP_UID = APP_OWNER.APP_UID;
>> DELETE FROM APP_THREAD USING APP_THREAD INNER JOIN APPLICATION WHERE APPLICATION.APP_NUMBER IN (8, 3) AND APPLICATION.APP_UID = APP_THREAD.APP_UID;
>> DELETE FROM SUB_APPLICATION USING SUB_APPLICATION INNER JOIN APPLICATION WHERE APPLICATION.APP_NUMBER IN (8, 3) AND APPLICATION.APP_UID = SUB_APPLICATION.APP_UID;
>> DELETE FROM APP_DELAY USING APP_DELAY INNER JOIN APPLICATION WHERE APPLICATION.APP_NUMBER IN (8, 3) AND APPLICATION.APP_UID = APP_DELAY.APP_UID;
>> DELETE FROM APP_DELEGATION USING APP_DELEGATION INNER JOIN APPLICATION WHERE APPLICATION.APP_NUMBER IN (8, 3) AND APPLICATION.APP_UID = APP_DELEGATION.APP_UID;
>> DELETE FROM APP_CACHE_VIEW USING APP_CACHE_VIEW INNER JOIN APPLICATION WHERE APPLICATION.APP_NUMBER IN (8, 3) AND APPLICATION.APP_UID = APP_CACHE_VIEW.APP_UID;
>> DELETE FROM APP_HISTORY USING APP_HISTORY INNER JOIN APPLICATION WHERE APPLICATION.APP_NUMBER IN (8, 3) AND APPLICATION.APP_UID = APP_HISTORY.APP_UID;
>> DELETE FROM APPLICATION WHERE APP_NUMBER IN (8, 3);
After that go to the ProcessMaker path
>> cd /opt/processmaker
Finally, run the migrate-new-cases-lists
./processmaker migrate-new-cases-lists