mysql result "one column n rows" doesn't works
Hi!
Following some tips from the bonita documentation and some answers from the forum, I tried to configure a mysql query to show it in a multiselect list wigdet as below ( I used the bonita community 6.3.2 ):
Create a field list_name type java.util.list;
Insert a connector and adjust the database access information to a MYSQL database;
Insert the following data in "Query or Batch Script": script name: selectMysql // selects all user emails String myQuery = "SELECT email "; myQuery= myQuery +"FROM users "; myQuery= myQuery +"WHERE valid = 1 ORDER BY email;"; return myQuery
Output operation definition: Select the output Expression type: Connector output >> oneColNRowResult (Return type: java.util.List)
The selected target was the field list_name
Create a form and insert a wigdet: List <java.util.List>
Available values receive the field list_name
When I save and run the the process, all the output connector parameters are gone.
Please, can somebody help me?
Thanks in advance!! Fabi
Comments
Hummm, your title and your output operation definition say something different.
Title : one column n rows Output Operation Definition : Connector output >> oneRowNColResult
Is this a typing error ? This could explain why it doesn't work.
Hi! Florian,
Sorry, was a typing mistake :o)
The parameters: Edit expression window: Expression type: Connector output Name: nRowOneColResult Return type: java.util.List
Maybe there's a 6.3.2 version's bug , or the community version doesn't accepts MySQL connections like that.
PS: I have two another connections (SQL Server and PostGre) working fine. I didn't understand why the connectors (SQLServer and PostGre) informs the column name direct in the field "Takes value of" and in the MySQL connector, the bonita suggests the "resultset" value.
Thanks for your concern,
Fabi
Yes, it could be a bug but you need an admin to confirm this.
I think it's a bug indeed. So, I try other way to do it.
Thank you for all. Fabi ;o)