Ask questions about installing and configuring ProcessMaker 3

Moderator: amosbatto

By ajcosta
#817657
Hi Amosbatto,

Just upgraded from Community version 3.2.1 to 3.2.3 and verifyed that my suggest control are not working if inside a GRID.
They work ok as a standalone.
I have them set up with the array variable option but have tried with databse query and also does not search/suggest.

Need urgent help on this.


Thank you

AJ
User avatar
By amosbatto
#822742
I just tried using SQL queries in suggest fields in grids in PM 3.2.3 Community (installed in Debian 9.5 with PHP 5.6.37 and Firefox 52) and it worked.

If you use this SQL query in the suggest box:
SELECT USR_UID, USR_USERNAME FROM USERS
Does it work?

If you are using a database connection, you should try creating a new database connection. If it still doesn't work, do you see any error in your web browser debugger under the "Console" tab?
(Hint: Press F12 in Chrome or Firefox to open the browser debugger.)
By ajcosta
#822764
Hi Amosbatto,

Yes with SQL query it works ok in a Grid, but with an ARRAY VARIABLE setup in a previous trigger, it does not work.
Please see:
https://wiki.processmaker.com/3.2/DynaF ... a_Variable

I'm using an example like:
Code: Select all
$result = executeQuery("SELECT CON_ID, CON_VALUE FROM CONTENT WHERE CON_CATEGORY='GRP_TITLE' AND CON_LANG='en'");
if (is_array($result)) {
    foreach ($result as $row) {
        @=varDataSource[]= array($row['CON_ID'], $row['CON_VALUE']);
    }
}
Thanks,

AJC

You executed cron.php correctly. What is your ques[…]

This is my query : SELECT * FROM ( SELECT IH.Ord[…]

Hi all, I'm looking for a way to change the defaul[…]

Hello, Thank you. But i think this is not the main[…]