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
#824500
Hey,
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.
Attachments
casenochange.PNG
casenochange.PNG (14.94 KiB) Viewed 1113 times
User avatar
By amosbatto
#824514
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 32 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;
executeQuery($sql);
Make sure to change this line in your workflow/engine/config/execute-query-blacklist.ini file from:
queries = "INSERT|UPDATE|REPLACE|DELETE|TRUNCATE"
To:
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.

okay thanks

Amosbatto, PMUsers.com is down.

It would be nice if ProcessMaker can let us know w[…]

Hi, What is your server config? Is your server Wi[…]

Filtering Grids For Parallel Tasks

Hi, You must create a grid for example @=tempGrid[…]