[processmakerlover]

Hi!

I have a problem about my process. I have two case in a task but I want to delete one of them because to continue my task.
I want to delete because I can see all data in other case.

How can I delete one of them, can you help me?

[dan123dan]

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