Share ideas, ask questions, and get feedback about developing for ProcessMaker

Moderators: ArturoRobles, ArturoRobles

Forum rules: Please post new questions under "Developing processes & programming" for ProcessMaker 2 or 3.
#785865
If you are using the community edition, you can use this code:
Code: Select all
if (isset(@@caseToReopen) and !empty(@@caseToReopen)) {
	$caseId = @@caseToReopen;
	//get last delegation index:
	$query= "select * from APP_CACHE_VIEW where APP_UID='$caseId' order by DEL_INDEX desc";
	$aCases = executeQuery($query);
    if (!is_array($aCases) or count($aCases) == 0) 
		die("Error: Unable to find case with ID '$caseId'");
	
	$index = $aCases[1]['DEL_INDEX'];
	$c = new Cases();
	$result = $c->ReactivateCurrentDelegation($caseId, $index);

	$query = "update APPLICATION set APP_STATUS='TO_DO' where APP_UID='$caseId'";
	executeQuery($query);

	$query = "update APP_CACHE_VIEW set APP_STATUS='TO_DO' where APP_UID='$caseId' and DEL_INDEX=$index";
	$aCases = executeQuery($query);
}
#822053
bgone1969 wrote:Hi Amosbatto,

Where should place this trigger?

Thanks & Best regards.
I have created a process that you can use to execute this trigger:
(25.21 KiB) Downloaded 154 times
You need to enter the case number of the case to reopen.

In your workflow/engine/config/execute-query-blacklist.ini file, change from:
queries="INSERT|UPDATE|REPLACE|DELETE"
To:
queries = "INSERT|REPLACE|DELETE"

Hello, I'm trying to make a HTML page in which a[…]

IOS PUSH Notification

Latest Mobileios.pem already get its SSL cert expi[…]

Enabling SQL Server in Windows

Nice. https://360digitmg.com/india/ethical-hacking[…]

PM 3.5.0 supports MySQL 5.7.X configurations with […]