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

Moderators: ArturoRobles, ArturoRobles

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.
#790411
Hello,

Do you want to store the case variables for the process in the database?
One approach you can use is:
* Create a trigger which executes the SQL query to insert the variables into a table of the database and set the trigger to fire at any step in your process.
* To query for SQL server will be similar to the MySQL queries, the only difference is in executing it. To execute the query for SQL server you will have to pass the id of the db connection in the executeQuery function, like:
Code: Select all
$db = "id of the SQL server connection";
$query = "INSERT INTO VAR_TABLE (ID, VAR, VAL) VALUES ("01", "name" , "ABCD")";
$result = executeQuery($query, $db);
Hope this helps

Best Regards
Mishika
#790436
Thanks for your support.

Yo tengo creado un trigger con nombre “uno”:

1.jpg

Y mis variables “Cantidad” y “Contiene” las tengo definidas de la siguiente manera:

2.jpg

Este es mi proceso:

3.jpg

Y en la task “Ingreso Correspondencia”, en “steps”, tengo agregado mi trigger “uno” creado anteriormente:

4.jpg

Esta bien esto? Algo me falta, porque no me almacena las variables en la BD.

Muchas gracias.
Attachments
4.jpg
4.jpg (65.27 KiB) Viewed 1710 times
3.jpg
3.jpg (14.62 KiB) Viewed 1710 times
2.jpg
2.jpg (24.94 KiB) Viewed 1710 times
1.jpg
1.jpg (28.4 KiB) Viewed 1710 times

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[…]