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

Moderator: amosbatto

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.
By njhajhajha
Im using Process Maker 3.3.6 community version.
I want to customize case number which are auto generated in Process Maker.

For example:change case 71 in this Page to 185201971(current date + case no)

Thank You.
casenochange.PNG (14.94 KiB) Viewed 1025 times
User avatar
By amosbatto
ProcessMaker doesn't support that. What you can do is write a new value to the APP_SEQUENCE.ID field in the database. Then the next case will add one to that value for its case number.
You could create a process with a timer event that executes a script task once per day that sets today's date in the APP_SEQUENCE.ID field. Set the timereventcron.php file to periodically executed by the server where ProcessMaker is installed.
Here is the process you can use:
(36.46 KiB) Downloaded 25 times
It contains this trigger:
Code: Select all
//Set to a value YYYYMMDD0, like 201905210 (today's date), 
//so the first case today will be 201905211 and the 
//second case will be 201905212
$todayDate = date("Ymd0"); 
$sql = "UPDATE APP_SEQUENCE SET ID="$todayDate;
Make sure to change this line in your workflow/engine/config/execute-query-blacklist.ini file from:
So the trigger can write to the APP_SEQUENCE.ID field in the database.

The other option is to set the customized case number in the case label.
Issue with File field


What version of PM are you using? When the user de[…]

Hide panel on new case list

Why don't you want to display that? (I'm asking b[…]

Oh, I made a mistake in my code. Change i to $i[…]