Questions and discussion about developing processes and programming in PHP, JavaScript, web services & REST API.

Moderators: ArturoRobles, ArturoRobles

Forum rules: Please search to see if a question has already asked before creating a new topic. Please don't post the same question in multiple forums.
#827119
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
disable value in dropdown

Check box is more helpful rather than drop down op[…]

Timeout Not Sending Email

I would like to thank you for the efforts you have[…]

use 'insert into' in a trigger

Is your syntax correct? Shouldn't you be using s[…]

issue with processmaker 3.2

You mean the code in the trigger below? That is t[…]