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

Hi, Is there any way to show my custom column only[…]

Send for clarification

Hi, I know this is an old post but i could not fin[…]

add dropdown to search process

Please replay if there is any solution!!!!

Amosbatto, PMUsers.com is down.

Hi Amos, I appreciate you setting up a tips and t[…]