how I may show a table's content in a form table?
2 answers
If you trying to retrieve table data from MySQL database and display these data in a table. You can follow following steps:
- Use a database query connector to access MySQL, that will give you a java.sql.ResultSet as an output.
- Prepare a
List<List<String>>object out of the ResultSet - Add a Table widget in your form, set the
List<List<String>>object as table data (by using option Edit as an expression).
Think this will help you somehow.
Comments
Many thanks for the reply,
but can you help me with this? How I create a variable List tipe?
I'm new in the "programming world" and also in BOS.
I would greatly appreciate if you help me further
This is the query that I want to use "SELECT * FROM proceso_rma".
To create a variable of type List you need : - Select you process and open the General/Data tab - Click on Add... - In the Data type field, select "Java Object" - The class "java.util.List" is selected by default, this is the class that you need - Validate and it's done
So many thanks, this really helped me
Comments
Which version of Bonita BPM are you using? You will not use the same solution for each version.
Also can you confirm that you want to display data in a read-only mode?
Yes, i just show the information in a read-only mode.
I'm using BOS 6.5.3
Do you know how can I do it?
Many thanks