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 995 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 24 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.
Disable grid using JavaScript

You need to disable the upload button in a Modal[…]

SOAP-ERROR: Parsing WSDL

Hello there, We are using PM Enterprise version 3[…]

Detail information, thanks for your sharing.

Don't forget to unblock the core tables: https:/[…]