[ajcosta]

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

[amosbatto]

Yes, I see this bug in PM 3.2.3 in grids. Please register a bug report about it at http://bugs.processmaker.com and post a link to your bug report here.

[ajcosta]

Just registered this bug with ID:

https://bugs.processmaker.com/view.php?id=26872

Upgraded to 3.3.3 and suggest controls still do not work if inside a grid.


AJC

[amosbatto]

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.)

[ajcosta]

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

[pawansaxena]

@ajcosta Did you find any solution for this ?

[pawansaxena]

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/DynaForm_Field_Properties#Data_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

Did you find any solution for this ?

[verenaleyo]

Label controls display the value of the field but do not have a width setting. In contrast ... Preview of the grid showing..



check https://surveydetails.com/

[blaijord]

Hi,
I think that I found the bug and I reported the solution on that topic:

https://forum.processmaker.com/viewtopic.php?f=44&t=738548