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.
#825733
Hi,
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?

Regards,

Fred
#825748
Follow the instructions on the wiki:
https://wiki.processmaker.com/3.3/Datab ... 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:
https://docs.microsoft.com/en-us/sql/co ... erver-2017

Here is the page to download the files:
https://www.microsoft.com/en-us/downloa ... 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.
#825773
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:
SELECT CLIENT_ID, CLIENT_NAME FROM CLIENTS WHEN [email protected]@selectCountry

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:
https://wiki.processmaker.com/3.2/JavaS ... ing_jQuery

To populate the list of options with JavaScript, see:
https://www.pmusers.com/index.php/Chang ... tions_list

Sending documents as base64 worked the last time I[…]

I don't see those problems using PM 3.3.10 Communi[…]

Tengo el mismo problema con el MultipleFile, inten[…]

Getting this error

_ERROR_ : The row '3149943815d31b85fdf39650326697[…]