[LouisLO]

Dear all,

I am new comer and using bitnami-processmaker-3.1-0-windows.

How to fetch data from MySql database and disaplay a list of record in Dyna form as below? Many thanks!

Staff ID Staff name
====== =========
123 Peter
222 Mary
333 John


Louis

[amosbatto]

Create a trigger and use executeQuery() to populate the grid. Create a grid variable named "staffList", Then create a grid associated with that variable in a DynaForm. Put two textboxes in that grid which have the IDs "staffId" and "staffName". Then create a trigger with the following code:

Code: Select all

//if using an Database Connection to an external database:
db = 'XXXXXXXXXXXXXXXXXX'; //set to unique ID of your Database Connection
@=staffList = executeQuery("SELECT STAFF_ID AS staffId, STAFF_NAME AS staffName FROM STAFF", $db);

See:
http://wiki.processmaker.com/3.0/Grid_C ... base_Query
http://wiki.processmaker.com/index.php/ ... base_Query
http://wiki.processmaker.com/3.0/Proces ... uery.28.29

[LouisLO]

Dear Amosbatto,

It works. Many thanks!

Louis

Create a trigger and use executeQuery() to populate the grid. Create a grid variable named "staffList", Then create a grid associated with that variable in a DynaForm. Put two textboxes in that grid which have the IDs "staffId" and "staffName". Then create a trigger with the following code:

Code: Select all

//if using an Database Connection to an external database:
db = 'XXXXXXXXXXXXXXXXXX'; //set to unique ID of your Database Connection
@=staffList = executeQuery("SELECT STAFF_ID AS staffId, STAFF_NAME AS staffName FROM STAFF", $db);

See:
http://wiki.processmaker.com/3.0/Grid_C ... base_Query
http://wiki.processmaker.com/index.php/ ... base_Query
http://wiki.processmaker.com/3.0/Proces ... uery.28.29

[DanDan]

Hi,

I have tried the suggested above but didn't find my luck.

1. I have set up a variable and a trigger
2. Put them in steps together with Dynaform
3. Run the form as regular user but I see nothing happen

Whats should I do?

[DanDan]

There's already few rows of grid but they have no data. Empty space only.

What should I do?

[DanDan]

Hello again,

Is it possible to Add new Row or change the data using this feature?


Many Thanks

[amosbatto]

DanDan, the names of the fields in your SQL query need to match the IDs of the fields inside the grid. You probably need to use "AS" to rename the fields.

For example, if you have a grid associated with the variable "clientsList" and inside your grid you have the fields with the IDs "firstName", "lastName" and "address", then your SQL query in the trigger needs to be:
$db = 'XXXXXXXXXXXXXXXXXXXXXXXXX';

Code: Select all

$sql = "SELECT FIRSTNAME AS firstName, LASTNAME AS lastName, CLIENT_ADDRESS AS address
   from CLIENTS WHERE GROUP='local clients' ";
@=clientsList = executeQuery($sql, $db);

[DanDan]

Hello amosbatto,

Thank you for your help, I'm using PM Tables for the data and I have successfully make it work because of your help.


The problem is, I can't edit the data or add a new row. How can achieve that? It says data submitted but no data change.

Thank you.