Store Data(from db) in a table dynamically

Q&A
1

Hello to everyone and i wish u to have a good week… :slight_smile:
I want to retrieve a list from data by database and insert dynamically in a table to Bonita Studio.
More specifically,i use BONITA STUDIO 5.9 Version and MySql for DB.(Wampserver)

For Example, i make a question :
" SELECT * FROM users" (users is database’s table,with “username”,“password”,“usertype” fields)

i would like to appear these data in a table dynamically.
The number of columns are specifically(3 fields),but number of rows change dynamically.
How can i do it?? and How can i store data in table??
Have anyone a idea?

Thank in advance
Katerina

2

Hi Katerina,

You can use Editable datagrid widget.
Here you have a post with an example: http://community.bonitasoft.com/groups/usage-operation-5x/save-data-editable-grid-mysql-database. Of course, you can improve the code.

Regards