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

Moderator: ArturoRobles

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

Hello ProcessMakers! We are extremely proud to an[…]

How processmaker load cases on home page of user? […]

Hey everyone, I'd appreciate any help you might be[…]

Error dynaform xml pm3

Thanks for sharing .