Fill table from mysql
Hi,
I try to show in a Table thez result of a query in mysql.
Table : Id, titre, description, date_ajout
I woul'd like to show the result in the table row by row like that:
1 | titre1 | desc1 | 2016-02-19
2 | titre2 | desc2 | 2016-02-19
3 | titre3 | desc3 | 2016-02-19
And not
[1,2,3] | [titre1,titre2,titre3] | [desc1,desc2,desc3] | [2016-02-19,2016-02-19,2016-02-19]
How can I do that?
Regards
BLE
Comments
Hi,
I take a look at that, but I'm not using the UI form but the native form of bonita!
Anyways to change the values with groovy script?
Regards
BLE
Have a look at this post...
http://community.bonitasoft.com/answer-postgres-query-result-list-lists-fills-only-first-column-form-table#comment-5333
regards
Hi,
Thank's for the link,
I try the script but it's not working, maybe it comes from the variable.
What kind of variable must I use? I use a java.util.List
And I put the script in a connexion in for a Mysql connexion
I put this request : SELECT "titre", "description" FROM demo
At the last screen I choose the variable listoftitre (java.util.List) take value of resulset, I edit and I put this code in script :
When I run, the form isn't available.
Thank's