Questions and discussion about using ProcessMaker 2: user interface, running cases and functionality

Moderator: amosbatto

Forum rules: Please search to see if a question has already been asked before posting. Please don't ask the same question in multiple forums.
#827566
Hello Everyone,
I have a problem in fetching the data from MS SQL Server,
I'm writing a very simple query to fetch the Customer's Id and Name in the Dropdown List, but I getting the below error

Notice: Array to string conversion in C:\opt\processmaker\gulliver\thirdparty\creole\SQLException.php on line 63
The SQL query as below, it`s working fine in SQL studio Management:
Code: Select all
select distinct iRepresentanteAtual, NomeGrupoRep FROM qryMapaClientes order by NomeGrupoRep

I'm using a PM 2.8 on Windows 10 and using Xampp V3.2.2 ( Apache/2.4.29 (Win32) OpenSSL/1.0.2n PHP/5.6.33 Apache 2.4 )

Any suggestions, please
#827640
Hi,
Please write your query in a trigger before your dynaform like this:
Code: Select all
$db = 'Your connection uid';
$query = 'Your query';
$result = executeQuery($query, $db);
print_r($result);
die();
Then check your result is true or not. You can fill your dropdown with trigger before your form.

https://www.youtube.com/channel/UCYiyz1y8Qf4EZjMXodwH1iw/videos
https://www.linkedin.com/in/pmlearning/
Thanks

Hi, Please set max_input_vars=8000 in your php.in[…]

Total cases using REST

I want to get total number of created cases using […]

Mixed content block

Hi everyone, I need some help as I am getting an […]

pmusers.org

Hi Amo, I saw your new post today and I can't rep[…]