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:
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:
queries = "INSERT|UPDATE|REPLACE|DELETE|TRUNCATE"
queries = "INSERT|REPLACE|DELETE|TRUNCATE"
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.