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

Moderator: amosbatto

#783597
Hi All,

Trying to integrate ProcessMaker into SQL Server is exceedingly frustrating. I finally have the ability to populate grids from SQL tables and write them back again but when I try to use views instead everything stops working.

@@test_grid_rows = 1234;
$result =executeQuery("select shoot_date from IMPORT_PROD_DETAILS_T","41500854455788435d04564021257676");
@=test_grid = $result;
@@test_grid_rows = count($result);

If IMPORT_PROD_DETAILS_T is a table, the trigger works fine. If it's a view, it never even returns from the call to executeQuery.
I can trace SQL Server and the query comes across fine and the data gets returned.

Any ideas of why this happens?
How can I get any debugging info on what's happening with executeQuery?

Thanks,

Santi

Thanks!

Hi, This user API https://wiki.processmaker.com/[…]

display pdf in panel control

Is there any solution?