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.
I need get some information from SQL Server, if I install Microsoft ODBC Driver for SQL Server in Linux, can use it in a trigger?
I have some information in SQL Server that need get using as key a form field in PM.
Some suggestions?


Follow the instructions on the wiki: ... ions/MSSQL

The instructions aren't complete if you are using ProcessMaker installed in Windows.
The php_dblibx64.dll library only works if you are using PHP 5.6. Please go to Admin > System Information in ProcessMaker to verify which version of PHP you are using.

If you are using PM 3.3.0 or later with PHP 7.0 or later in Windows, then you need to follow these instructions to install
the SQLSRV and PDO_SQLSRV drivers: ... erver-2017

Here is the page to download the files: ... x?id=57916

After you have installed the PHP files for MSSQL, then you can create a Database Connection that connects to your installation of MSSQL. Then, you can use the ID of the Database Connection when calling the executeQuery() function in a trigger.
The easiest way to use the value from a Dynaform field in your SQL query is to use a dependent field.

The dependent field query will automatically happen when the value of the independent field changes.
For example, if your SQL query is:

Then, the query will happen automatically when the value of the "selectCountry" field changes.

If you want to do this the hard way and control this with the click of a button, then you can use jQuery's $.ajax() function to call the following REST endpoint:
POST project/{prj_uid}/process-variable/{var_name}/execute-query-suggest

See this example of how to call REST with JavaScript: ... ing_jQuery

To populate the list of options with JavaScript, see: ... tions_list

Hola, Podrías utilizar un 'start timer eve[…]

Hi, I think that this is not possible because at[…]


Hi, Please set the display_errors = Off in your […]