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.
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'";

	$query = "update APP_CACHE_VIEW set APP_STATUS='TO_DO' where APP_UID='$caseId' and DEL_INDEX=$index";
	$aCases = executeQuery($query);
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 152 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:

Maybe try increasing your thread stack size? Seems[…]

I use PM 3.4. Android push works while IOS push do[…]

[quote=ziadeh post_id=823031 time=1550759948 user_[…]

I have to support reports in processmaker 3.4. A s[…]