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
Call Help Center

pinterest help , contact pinterest , pinterest ph[…]

thank you for your Interest but I found problem […]

Hi, Some times the executeQuery function is not […]

Link Logo

Nice topic. Its very useful about link logo desi[…]